Criteria not working in query

[Guest]

I have a query with the following criteri

Field2 Field 1 Dat
Table Tabl

False >=

![Field2]+ 5

I am trying to get all data where field one has a value of false and field two is 55 days after the current dat
however the query is not giving the desired results. How would I resolve this issue

Thank you nicole

 

[Lauri]

Does Field2 have the current date? Why?
In access 2000 you should be able to use the criteria >=Now()+55

-Lauri

I have a query with the following criteria

Field2 Field 1 Date
Table Table

False >=

![Field2]+ 55

I am trying to get all data where field one has a value of false and field

two is 55 days after the current date

 

[John Vinson]

I have a query with the following criteria

Field2 Field 1 Date
Table Table

False >=

![Field2]+ 55

I am trying to get all data where field one has a value of false and field two is 55 days after the current date
however the query is not giving the desired results. How would I resolve this issue?

Thank you nicole

Word wrap makes this VERY hard to read. Please post the SQL view of
the query, and also indicate what the value in Field2 might be.

If you are putting in a third calculated field Date(), you don't need
to - just put

=DateAdd("d", 55, Date())

as a criterion to return those records with July 6, 2004 in Field2
(that's 55 days from today). Note that records with July 5 and July 7
will not be retrieved; and if Field2 contains both a date and time,
nothing will be retrieved since the time must match to the microsecond
and probably won't!

 

[Guest]

field 2 does not have the current date. What I am trying to figure out is if todays date is greater than or equal to the date in field 2 + 55 days

 

[John Vinson]

What I am trying to figure out is if todays date is greater than or equal to the date in field 2 + 55 days

Then put a criterion on Field2 of

<= DateAdd("d", -55, Date())