Calculated Query?

[Tansar]

Hi,
I am trying to display all records that are 30 days old from date of registration (& not paid). I have:

30 Days: [SrDate]+30
SrPaid = No

But I don't want to see those that have registered in the (say) last few days, but only those that have not paid and 30 days are up. How would I achieve this?

Thank you

 

[Michael J Ross]

Put this as criteria, under Date of Registration field <=Date()-30 and under your paid field "No".

 

[Tansar]

Excellent...Thank you!