X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> End Date Formula For Multiple Events At A Venue, Access 2016    
post Apr 16 2018, 05:07 PM

Posts: 19
Joined: 13-April 18

I am trying to create a formula to grab an end date for an event at a particular venue that has multiple end dates any idea how i could do this?

for example
venue performer date
pepsi center lady gaga 4/5/2018
lady gaga 5/5/2018

Rup Arena REO speedwagon 4/6/2018
REO Speedwagon 5/6/2018

Go to the top of the page
post Apr 16 2018, 05:10 PM

Access Wiki and Forums Moderator
Posts: 74,687
Joined: 19-June 07
From: SunnySandyEggo


Have you tried using a Totals query? It might look something like this:

SELECT Venue, Event, Max(EndDate) As LastEventDate
FROM TableName
GROUP BY Venue, Event

Hope it helps...
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    24th March 2019 - 08:31 PM