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

Help with Report?

P: 12
I have 3 tables

1st is Vehicles= reg make etc
2nd is employees= employee id, name surname etc
3rd is entry logs=registration, employee id and date (usually one each 2 weeks)

How can I get a report to show me only the last entry for each employee or same report but for last record for each vehicle? (entrys are not all at same stage or date - e.g employee 1 may not have upadted his log for 3 weeks)

Any help much appreciated.

Many thanks Adrian
Aug 25 '06 #1
Share this Question
Share on Google+
1 Reply

P: 48
Hello Adrian,

Make a query, add Entry Logs and Employees and join them on Employee ID, add the necessary fields and use the function Max or Dmax on the date field to select the last entered Log record. Same for vehicles if you have a field to join the Vehicles table to the rest..

Did it work? Sander
Aug 29 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.