W
william
Hello
Having trouble trying to get a query to work.
What I'm trying to do is create a query based on an Inspections table
that will return the most recent inspection completed for each room.
One room can have many inspections done on different dates. So I built
query, clicked Totals, and have the following three fields: Room
(GroupBy), InspectionDate (Max) and Room (Count). This gives me what
I'm looking for. For example Room 9A, 12/26/05, 6 (6 total inspections
for Room 9A). The problem is that I need the InspectionID of the most
recent inspection to appear as well. I don't know how to include that
in a query using Group By. Is there a way to do this or am I going
about this incorrectly to begin with.
Any help is greatly appreciated.
William
Having trouble trying to get a query to work.
What I'm trying to do is create a query based on an Inspections table
that will return the most recent inspection completed for each room.
One room can have many inspections done on different dates. So I built
query, clicked Totals, and have the following three fields: Room
(GroupBy), InspectionDate (Max) and Room (Count). This gives me what
I'm looking for. For example Room 9A, 12/26/05, 6 (6 total inspections
for Room 9A). The problem is that I need the InspectionID of the most
recent inspection to appear as well. I don't know how to include that
in a query using Group By. Is there a way to do this or am I going
about this incorrectly to begin with.
Any help is greatly appreciated.
William