Simple Date Query

[AimeeK via AccessMonster.com]

Hi, I'm trying to develop a query in which a user would have to input just
one date, and it will return records that are either equal or less than this
date. Access seems to want to pull records matching that date EXACTLY, and I
don't want that to happen. I also do not need to specify a date range.
Anything I can do in query design view that will help this? The query is
called qryFindContractsbyDate, and the field I'm looking to filter the
records by is called [CONTRACT END DATE]. For Example, I'd like a parameter
box to come asking for a date, and the user types in 11/30/06. I'd like any
records with a CONTRACT END DATE less than or equal to 11/30/06 to come up.
Thanks in advance for your help.

 

[Guest]

Use this as criteria on your [CONTRACT END DATE] field in the query.

=[Enter last contract end date]

Hi, I'm trying to develop a query in which a user would have to input just
one date, and it will return records that are either equal or less than this
date. Access seems to want to pull records matching that date EXACTLY, and I
don't want that to happen. I also do not need to specify a date range.
Anything I can do in query design view that will help this? The query is
called qryFindContractsbyDate, and the field I'm looking to filter the
records by is called [CONTRACT END DATE]. For Example, I'd like a parameter
box to come asking for a date, and the user types in 11/30/06. I'd like any
records with a CONTRACT END DATE less than or equal to 11/30/06 to come up.
Thanks in advance for your help.

 

[Guest]

Should be <=

 

[AimeeK via AccessMonster.com]

It worked! Thank you very much!

Should be <=

Hi, I'm trying to develop a query in which a user would have to input just
one date, and it will return records that are either equal or less than this

[quoted text clipped - 6 lines]

records with a CONTRACT END DATE less than or equal to 11/30/06 to come up.
Thanks in advance for your help.