need help with a query

[blooberrys]

Im making a booking system and i need a query to find overdue overdue payments.

so in the "total owed" field i have >0.

i need to put something in the "payment due date" so it displays all records after the payment due date.

this is probably a really easy question to one of you but i havent got a clue!

thanks

 

[JANR]

If "Payment Due date" is a date/time field, then put < Date() in the criteria

JR

 

[blooberrys]

yes it is a date/time field but wouldnt <date() show all records with due dates prior to the day the query was run rather then the date in the field?

i need it to show all records where the due date was in the past

 

[JANR]

It will show all the records which has a duedate less than todaysdate as in when you run the query.

> Date() will show records that isen't due yet.

JR

 

[blooberrys]

oh yeh i was being a spaz lol

thanks mate