Top 1 for each category query

[icon242]

I am working on a fairly simple inventory database in order to keep
track of parts on specific devices for the sake of testing.

I am trying to make it to that users can see what the current
configuration is for each device. This is because there are multiple
entries for one particular part in order to keep the history of the
device in the system.

I am having a hard time creating a query which can have the top ID# for
each component for each device. I can make it so that I can have a
report for a very specific component on a specific device, but I cannot
figure out how to make a report which displays ALL of the current
components on one or more devices.

I believe the best way for me to display this information is in a
report.

Also, I am not terribly literate in VBA, although I can do some minimal
commands using Google and other resources to assist.

Please help! Thanks in advance.

 

[Allen Browne]

See:
ACC2000: How to Create a "Top N Values Per Group" Query
at:
http://support.microsoft.com/kb/210039/en-us

If the target is a report, it is often easiest to use a subreport. The
subreport query runs for each record in the main report, and returns the
desired TOP records. More info:
http://support.microsoft.com/kb/208822/en-us