query criteria for current date

[Paul-NY]

Hi
I am in Access Query Design view creating a query that retrieves records that are greater than the curernt date.

In the date database field, I am putting the one of the following:

> Date()

or

> Now()



Neither of these is returning records that are greater than the current date. Anyone have any ideas?

Paul

[pbaldy]

Where exactly are you putting it? The first should work in the criteria row under your date field.

[Paul-NY]

That is exactly where it is going--see screenshot below, but it retrieves everything when it should not return anything.

Paul

[pbaldy]

The criteria on the second line on the LocationCode field is an "OR". If you look at the SQL, you're basically saying

WHERE (A And B And C) OR D

So anything with a LocationCode of L03 will be returned, regardless of date or type code. If you want the date and TypeCode criteria applied to that Location code, you need them on the second line as well.

[Paul-NY]

That did it, thank you very much..

Paul

[pbaldy]

No problem; us Paul's have to stick together!