Access Query

  • Thread starter Thread starter Charlene Potter
  • Start date Start date
C

Charlene Potter

In a query, how can I create a parameter for dates? What
if you don't know the exact day, but you know the month
and year? How do I do this. Please help..... Thanks.
 
To specify a parameter to be a date, go to Query / Parameters, enter the
parameter name, and select the date datatype.

Parameters are a very simplistic. They are not very flexible in accepting a
full date vs. partial date. You will need to create the functionality with
code or a more flexible query criteria.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
-----Original Message-----
In a query, how can I create a parameter for dates? What
if you don't know the exact day, but you know the month
and year? How do I do this. Please help..... Thanks.
.
Charlene,
Click to expand...

One way to do this is to set your criteria as greater than
or less than < the date. Like this:
Click to expand...
=#10/01/2003# And <=#11/01/2003#
Click to expand...

If you don't know the exact day, I would just start with
the first day of the month (that you do know), and do a
greater than/less than criteria. I hope this helps!

Sandi
 
Back
Top