another quick one

[wort0987654321]

i would like to be able to display all of the cars in my database that are due back today or haave not been returned to the company but should have been. so thats basically searching for cars that are due back today and days dating back from todays date

any help would be much appriciated

thank you

 

[Mile-O]

SELECT CarField
FROM MyTable
WHERE (DueDateField = Date() AND ReturnedField = False) OR (DueDateField < Date() AND ReturnedField = False);


Something like that...don't know what fields you have...but I'm sure you get the idea.

 

[wort0987654321]

this doesnt seem to work.

when i enter the code that you have given me and change it to the fields i have in my table this appears:

the in operator you required needs parentheses

is there anything else you can suggest


i also have the body

 

[KKilfoil]

In the query design grid, under your field for [returned], put 'False' (without the quotes), and under your field for [DateDue], put '<=Date()' (without the quotes) ON THE SAME LINE.