Need help for my query

[amoney61]

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

 

[PWise]

try

Select empname,max(medtestdate)
from medtests
group by empname
having max(medtestdate)<dateadd("m",-1,date())

 

[PWise]

sorry s/b

Select empname,max(medtestdate)
from medtests
group by empname
having max(medtestdate)<dateadd("m",-1,date())

 

[PWise]

sorry s/b


CODE

Select empname,max(medtestdate)
from medtests
group by empname
having max(medtestdate)<dateadd("m",-11,date())

 

[amoney61]

I'll try, thanks

 

[amoney61]

working fine, thanks.
I put some other fields and iif instructions for alerts.
thanks again.