Criteria not working in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Does Field2 have the current date? Why?
In access 2000 you should be able to use the criteria >=Now()+55

-Lauri

Nicole said:
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
Click to expand...

two is 55 days after the current date
 
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
Click to expand...


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!
 
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
 
What I am trying to figure out is if todays date is greater than or equal to the date in field 2 + 55 days
Click to expand...

Then put a criterion on Field2 of

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