SQL RECORDS EQUAL TO OR GREATER THAN DUE DATE 1

[barry2004]

Hi guys i have a database used for tracking equipment loaned out to staff. It is comprised of a form called frm_loan derived from tbl_loan which has "Date Out", "Due Date" & "Date In" Fields.
The "Date Out" Field has a Default value of "=Date()" and the "Due Date" is derived from formula "Due Date: CLng(([Date Out]+7))".
I would like to create a query that would show me all records where the "Due Date" is equal to today or has passed.
As always your assistance is appreciated.

 

[dhookom]

Set a criteria under the Due Date field to <=Date()

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]