Matching Data

[Guest]

Hi, Please help...

I am trying to build a query to look at an exception of jobs planned.
I have a table of No Entry visits, Job Num, Visit Date ( this talbe can
have a multiple number of visits) my second table looks at the appiontments
of jobs with again job number, appointment date. I am trying to look at appts
that are greater than the last no entry visit date, and only one job number
not multiple. How can I run this as a query?

Thanks
Jez

 

[kingston via AccessMonster.com]

Create a totals query on your first table: Group By Job Num, Max Of Visit
Date. Then make a query based on that query and the Appointments table and
join on [Job Num]. Output [Appointment Date] with the criteria >
[MaxOfVisitDate]. Please explain what you mean by "only one job number not
multiple".