UtterAccess.com
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    
 
   
ppcaccesshelp
post Apr 16 2018, 05:07 PM
Post#1



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


Thanks!
Go to the top of the page
 
theDBguy
post Apr 16 2018, 05:10 PM
Post#2


Access Wiki and Forums Moderator
Posts: 73,227
Joined: 19-June 07
From: SunnySandyEggo


Hi,

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...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    20th September 2018 - 01:22 PM