parameter querie

  • Thread starter Thread starter matthda
  • Start date Start date
M

matthda

After creating parameter queries I will be promted for the Information twice.
What am I doing wrong?
 
After creating parameter queries I will be promted for the Information twice.
What am I doing wrong?
Click to expand...

I don't know; what are you doing? We can't see your query.

What you might want to consider (especially if you're using the parameters in
a query and a subquery, or in a Report, etc.) is create a little unbound Form
named frmCrit with textboxes for the paramters. Rather than a prompt like

[Enter start date:]

use

[Forms]![frmCrit]![txtStartDate]

This will also let you put a command button on frmCrit to open the Report or
Form on which the query is based, so the user doesn't need to see the query
datasheet at all.
 
Please show us the SQL statement for the query. While in query design view,
go to SQL view. Copy the sql statement and post it here.
 
You must log in or register to reply here.

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

Similar Threads

Query Parameter using multiple options 0
Modify Parameter Query 1
parameter box 4
How to create Data Access Page from query with user-defined parame 1
Parameter Value error in a Subform 0
Using Date parameters in select queries Access 2003 5
Access Invalid bracketing of parameter name 1
Parameter Query 2

Back
Top