Home > Microsoft Access Help > Calculated Query

Calculated Query

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

Paid = No

But I don't want to see those that have registered in the (say) last few days. How would I achieve this?

Thank you

Guest

if you use something like this, it should only

show you the records that are 30 days and older

and where paid is no

Code:



select * from theTable where datediff("d", SrDate, now()) > 29 AND Paid = No

hope this helps

Was this answer helpful ? Yes No

Guest

Thanks for that

How do I translate that into Access?

Was this answer helpful ? Yes No

Guest

Quote:

Originally Posted by myself1

How do I translate that into Access?

That IS Access SQL. Just open your SQL View of the Query and copy the SQL that nofriends gave you.

Was this answer helpful ? Yes No

Guest

Answer it

Ask Question About Microsoft Access Help

Calculated Query

Programming

Related Pages