Parameter Queries - duplicating parameters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a DB that contains a field called chapter # (among many other fields).
My parameter query allows entry of a range of chapters #'s or I can hit enter
for the "from" and "thru" and all chapters are selected. This query works
fine. The parameter boxes (1st Chapter # / Last Chapter #) are only presented
once.

I have a 2nd query that prints a few of the fields from the 1st query. The
problem I am having is that the parameter boxes are presented TWICE in the
2nd query. I don't even reference the parameters in the 2nd query ... the
only reference is that the 1st query is the input into the 2nd query.

It didn't used to do this ... I don't know what's gone wrong. Can anyone
help me?

Thanks!!! I'm using Access 2002.
 
What do you mean when you say that you have a query that prints a few fields
from the first query? If you need to print a few fields from the first
query you would do better to make a report based on the first query, and add
just those few fields to the report. If you want the look of a datasheet
grid you can design the report to simulate that.
As for seeing the parameter dialog boxes twice, I expect it has to do with
basing a query on a parameter query. If you need a second query you would
do better to base it on the table.
 
Back
Top