Min/Max Dates and Group By

A

Andy

I have a small table of data:

Start End Appointment Date
11-Sep-09
26-Feb-10
26-Apr-10
10-Jun-09 12-Mar-10
10-Jun-09 26-Apr-10
10-Jun-09 12-Nov-09 11-Sep-09
10-Jun-09 12-Nov-09 12-Nov-09
06-May-10 06-May-10

I am tring to find the maximum date for each combination of start/stop.
Applying a max function to the appointment date in a query returns just two
records, not four

Start End MaxOfAppointment Date
10/06/2009 26/04/2010
10/06/2009 12/11/2009 12/11/2009

The minimum function returns four rows and it all seems correct for min?!
Why is this not working for Max please?
 
D

Daryl S

Please post your SQL so we can help you out. Go into query design and select
SQL View, then copy/paste into your reply.
 
A

Andy

Thanks Daryl. I have re-written the query and it now works - strange. The SQL
is completely the same both before and after and the data hasnt changed!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top