By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,122 Members | 921 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,122 IT Pros & Developers. It's quick & easy.

Latest Date Query

P: n/a
I have a table that includes fields InspectionDate and BuildingNumber.
I would like to query the data to return records showing the most
recent InspectionDate for each unique BuildingNumber. There are about
150 unique building numbers. Use of either query criteria or VBA
techniques are OK. Thanks in advance for any help or guidance.

Tony

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Fri, 13 Aug 2004 16:38:20 GMT, Hu***************@lerc.nasa.gov
(Tony Schoeffler) wrote:

You want to create a Totals query, which groups by building number.
Then get the Max of your InspectionDate:
select BuildingNumber, Max(InspectionDate) from MyTable
Group By BuildingNumber

-Tom.

I have a table that includes fields InspectionDate and BuildingNumber.
I would like to query the data to return records showing the most
recent InspectionDate for each unique BuildingNumber. There are about
150 unique building numbers. Use of either query criteria or VBA
techniques are OK. Thanks in advance for any help or guidance.

Tony


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.