count 30 days queries

[harky]

hi
Can some one help me with a query?
I have a database named login1 with a table called orderoil. i am looking to get the clients details in a table if they have not paid there bill after 30 days.
I have a Purchase_Date this tells u wat date they ordered the oil what other fields do i need for it to count 30 days and tell u that the account is over due.

Please help for a project worth 70%

Thanks claire

[harky]

how do i get the query to run?

[harky]

hi
im looking to run a query, i need it to read so that after 30 days it will show who has not paid there bill.

thanks claire

[nico5038]

Guess you have a "PayDate" to test for the payments and a "SubcriptionDate" to validate the period of 30 days.
Just use a WHERE like:

WHERE Date() - PayDate >=30 and IsNull(SubscriptionDate)

Getting the idea ?

Nic;o)

[MMcCarthy]

Hi Claire

Please do not double post your questions. Please see the FAQ on this issue. I have merged the two threads.

ADMIN

[harky]

Where do i put this code???
im new to this

Guess you have a "PayDate" to test for the payments and a "SubcriptionDate" to validate the period of 30 days.
Just use a WHERE like:

WHERE Date() - PayDate >=30 and IsNull(SubscriptionDate)

Getting the idea ?

Nic;o)

[nico5038]

You can open the query when in the editor to show the SQL text (See the query menu) and specify the WHERE clause.
After switching back into the graphical mode you'll see how it words graphically.
Just make sure that the fieldnames are correctly spelled !

Nic;o)