Finding the correct record...

[Sam]

Help. I'm writing a personnel tracking database. At this time, I have two
tables. First table is "Main Table". It has everyone's unique barcode from
their ID, names and personal data. The second table is "Scan Time". This
table is joined to the first table through the barcode and also has the
date/time and if the person is scaning in "1" or out "2". I have built a
query that returns the last time the person has scanned in and scanned out.
Basicly two records for each person. What I'm trying to get is the LAST
ACTION everyone has done. Either scanned in and the time, or out and the
time. Who is still in the building and who is not. Thank you for your time
in this matter.

 

[Allen Browne]

See:
Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm

The article explains 4 ways to query this information.

 

[Sam]

Allen,
This helped me allot. Thank you very much.