Criteria between two dates in Access 2003

[spcscooter via AccessMonster.com]

I need help...

I have a query that has two fields that calculate dates. I need to pull
entries that fall between those two dates only. I have used BETWEEN, >=,<=,
and I don't know where else to go. Here is the example that I am talking
about

Field 1
90DaysOut: DateAdd("d",90,Employees!CommTech1Start)
Field 2
120 Days Out: DateAdd("d",120,Employees!CommTech1Start)

I need to have the query only display the dates between these two fields.

Please help...

If you need any other info I will give you as much as you need.

p.s. I don't know anything about VBA so I am using the expression builder in
the criteria.

Thank you so much,

Scot

--
Scot Rawlings
Technical Trainer
Comcast
Auburn, WA

Message posted via AccessMonster.com

 

[Douglas J. Steele]

Are you saying that you want only those rows wheter CommTech1Start is
between 90 and 120 days from today?

Realistically, you don't need to add those two computed fields to your
query: all you need do is use the Criteria.

Underneath CommTech1Start in your query grid, put the following as the
criteria:

BETWEEN DateAdd("d", 90, Date()) AND DateAdd("d", 120, Date())

 

[spcscooter via AccessMonster.com]

Perfect... Thank you very much.

Are you saying that you want only those rows wheter CommTech1Start is
between 90 and 120 days from today?

Realistically, you don't need to add those two computed fields to your
query: all you need do is use the Criteria.

Underneath CommTech1Start in your query grid, put the following as the
criteria:

BETWEEN DateAdd("d", 90, Date()) AND DateAdd("d", 120, Date())

I need help...

[quoted text clipped - 22 lines]

Scot