order of Parameter prompts Changed

[babs]

I have a report and just looked at the design view and looked in design view
of Some of the queries that feed it- there is an invoice date prompt ( coming
from a query within it) a material date prompt from another query with in it,
a write-up date prompt again from a dif. query with in it - these all are
Part of the design view of the report. the prompt ORDER changed- but of
course did not THINK i changed anything???

When there are mANY Paremeter queries tied to A report - what affects the
"order of the prompts"???

thanks,
Barb

 

[Marshall Barton]

I have a report and just looked at the design view and looked in design view
of Some of the queries that feed it- there is an invoice date prompt ( coming
from a query within it) a material date prompt from another query with in it,
a write-up date prompt again from a dif. query with in it - these all are
Part of the design view of the report. the prompt ORDER changed- but of
course did not THINK i changed anything???

When there are mANY Paremeter queries tied to A report - what affects the
"order of the prompts"???

There is no humanly discernable order to parameter prompts.
The ones in your queries can come in any order as the query
optimizer reorganizes the queries and combining report
prompts (through the internally generated report query) just
make it even more incomprehensible.

Instead of using the quick and dirty parameter prompts, you
should create an unbound form with text boxes for users to
enter the information. Then the queries and report can use
references like:
Forms,[name of form].name of a text box]
instead of the prompt strings.