Using a calculated field from a form in a query 1

[Emmie1]

Hello!
I'm not sure if I'm in the right place, but here goes....

I have a form "Customer Entry" that I created in Access 2002. In this form I have a calculated field based on "Customer Table".

Outstanding Days =IIf([phone call date]<>"" And (IsNull([completion notification])),[Date]-[phone call date],IIf([phone call date]="","",DateDiff("d",[phone call received],[completion notification])))

My question is, how do I access the "outstanding days" data? I would like to run a query that shows me any records that has an outstanding days balance of 30 days or more. It sounds very simple, (which I'm sure it really is).I've been researching it for about 2 hours now and I'm about to SCREAM!!

Any help would be GREATLY appreciated!

Thanks,
Emmie

 

[PHV]

SELECT ...
FROM ...
WHERE 30<=IIf(IsDate([phone call date]),IIf(IsNull([completion notification]),Date()-[phone call date],DateDiff("d",[phone call received],[completion notification])),0)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Emmie1]

Thank you very much PHV for your wonderful help! It worked perfectly! You're the BEST!!

Thanks again,
Emmie