Simple Date Query

  • Thread starter Thread starter AimeeK via AccessMonster.com
  • Start date Start date
A

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.
 
Use this as criteria on your [CONTRACT END DATE] field in the query.
=[Enter last contract end date]
Click to expand...

AimeeK via AccessMonster.com said:
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.
Click to expand...
 
It worked! Thank you very much!

KARL said:
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
Click to expand...
[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.
Click to expand...
Click to expand...
 
Back
Top