Query help

[Webb]

Hello-

I have a database that is used for scheduling psychiatric appointments. I
have a main form with client information and a subform with clinic date
information. The subform is in datasheet view, so that I can see all the
appointments each client has ever had.

My subform has the following fields:

Appointment Date, Appointment Time, Med Expiration Date, Reason for Visit
and RTC Due

I need to make a query that will tell me who is past their Return to Clinic
Date, and by how many days or months? Plus show when their med expiration
date is.

Any ideas or suggestions?

Thanks
LaDonna

 

[Webb]

I just read this, and realized I probably didn't explain this very well.

What I need is a query that will calculate the number of days from the last
RTC Due Date entered to Now(). Does that make sense?
LaDonna

 

[Roy]

Hey Webb,

i'm not pro but i think i can alteast suggest since no1 replied to you yet
anyways..
you want the variace between the customer's last visit date & his latest
visit right?... so you can use "DATEDIFF" function here
=DateDiff("d", [datefield....], [datefield....])
and if its not clear yet then you can search in access about datediff
function it will might help you..i hope this will solve you prb.