Using Date parameters in select queries Access 2003


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?
 
Ad

Advertisements

J

Jahedur Rahman

check your parameter values (begin date & end date) it that contains time.
If true then format it like 'mm/dd/yyyy'
 
R

RES

Where are the parameter values? I've looked at the field properties in the
query, they are set to Short Date too.
 
R

RES

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.
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top