Display latest entry

[Muzicmn]

hi,

I have a database that tracks events that happen periodically. My problem is that we need to generate a report that includes data from the latest event. For example, we genereate a "Tapetalk" to controllers on different cycles, some of them every 6 months and some might be monthly. Also at different intervals, depending on the employee we genereate an employee summary report and this report must have the comments of the most current "Tapetalk"

I am just not sure how to make this happen. Any help would be greatly appreciated

Ricky

 

[Len Boorman]

Add a date/Time field to the relevant table. Set default to Now()

You can now select Max value of this field to get latest entry. Couple this with a person ID and you get latest entry for that person ID

HTH

Len B

 

[Muzicmn]

thanks len will give it a shot

 

[maxmangion]

do you mean that you want to use the latest event according to the most recent date ? If that is the case then use the DMax() function