Most recent date

[Robbie Doo]

I have a query that has 2 date fields and a fiscal period of 6 months among
others. One date fields is "Report Date" and the other "Meeting Date". Every
month on a meeting day they present the Fiscal period by the end of the
previous month in preliminary report until it gets finalized. For example:

Meeting Date Report Date Fiscal Period
7/17/2008 6/30/2008 Mar-Sep
8/15/2008 7/31/2008 Mar-Sep
9/16/2008 8/31/2008 Mar-Sep
......an so on until the next Fiscal period.

My inquiry is if I can Pull the latest Reported Date in that Fiscal Period
to present in the meeting.
Thank you.

 

[Jeff Boyce]

It sounds like you are saying that you need the Maximum [ReportDate],
grouping by [FiscalPeriod].

By the way, won't the "Mar-Sep" fiscal period show up every year? How will
you know which year you are working on?

Regards

Jeff Boyce
Microsoft Office/Access MVP