Hello, I need help with my query.
I built a db of people who needs to have a medical check each year for their job.
for each name a new date and result is enterd for each yearly check, then based on a query I made a mask who is checking dates and showing an alert one month before the new check.
What I can't do is to "tell" to the query how to choose one entry only for each name and the one with the higher (newest) date.
I someone able to give me a tip?
Thanks
I built a db of people who needs to have a medical check each year for their job.
for each name a new date and result is enterd for each yearly check, then based on a query I made a mask who is checking dates and showing an alert one month before the new check.
What I can't do is to "tell" to the query how to choose one entry only for each name and the one with the higher (newest) date.
I someone able to give me a tip?
Thanks