Using Date parameters in select queries Access 2003

  • Thread starter Thread starter RES
  • Start date Start date
R

RES

I've got a db that was created that uses a select query that calculates
future dates on a form called qryPMInfo that is based dates from the table
tblPMInfo which are formatted with short date. This query is used throughout
the db. My problem is when I use this query without parameters for example
Between #3/01/2010# and #3/31/2010# parameters in the criteria area 3 records
are displayed, which is correct. As soon as I put in a parameter of Between
[Begin Date] And [End Date] in the criteria area of the select query, 2
records display. What am I doing wrong?
 
check your parameter values (begin date & end date) it that contains time.
If true then format it like 'mm/dd/yyyy'
 
Where are the parameter values? I've looked at the field properties in the
query, they are set to Short Date too.
 
Ok, I added the Query Parameters in Query Parameters menu to Begin Date date
format and End Date to date format. It works. Thanks.

Can I combine 2 date parameters in the select query or do I need to keep
them separate to run a report using subreports.
 
Back
Top