group by query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Address table for employees. Pk Autonumber field, emp ID, and change of
address date. I am trying for Max date to get current address for all
employees. Max date then group by emp ID. How do I get PK for the records?
When I try to add I get all records. Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Distinct employee training query 3
State abbreviation MI fails in query 2
DMAX on UPDATE with INNER JOIN 5
what's wrong with my query 2
Query Sorting 5
Punch time query to calculate total work time 5
Grouping - Distinct 5
Seeing what does not match in a query 4

Back
Top