Getting the last shipments by Location

[nagiese]

I've been asked to pull the last shipment from each location for December of 2012. I have my data by location and date, so how to I write a query that will show only the last shipment date for each location? :banghead:

Thanks for all your help

 

[pbaldy]

Try this, with a parameter on the date field:

http://www.baldyweb.com/LastValue.htm

 

[nagiese]

This worked great.

Thanks a bunch

 

[pbaldy]

Happy to help!