Need total of claims over 30, 60, and 90 days 1

[proflola]

Hi all,

I'm sure this isn't too hard and if I gave myself enough time, I could figure it out....however...

I have a query that displays the following fields:

Case# rcvd_dt cmp_dt


I need to do a TOTALS query that will count the total cases
Then I need to use WHERE to age the rcvd_dt 30 days
The cmp_dt is null so that I can see only Open claims

I'm not sure how to write the expression to age the rcvd_dt.

Any help would be most appreciated.

Thanks,

SJD

 

[PHV]

Age: Date()-rcvd_dt

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[proflola]

Thank you, PHV! It got me past my "Access query" block.