Parameter Query Prompt Repeats

[Data Cruncher]

I have a report based on a query with a prompt for my
parameter query: >=[Enter date of first transaction].

When the report compiles, the query prompt is displayed as
each page is compiled, so for a 16 page report, I have to
input the transaction date 16 times.

THEN, when I go to print the report, I am again prompted
for the same parameter info.

Suggestions?

Thanks.
BTW, when just the query is run, I do not have this
problem.

 

[Guest]

It seems we are having a very similar problem. Look at my post about 10
posts down on 10-07-04 called "Select Query Parameter Repeating". If someone
reply's to mine it may help you as well and vice versa.

 

[Guest]

Data Cruncher,

I found this post and I found it helpful for our problem. Hopefully this
helps you....




You were right.... Now I understand!

What I did was:

1. Design a query
2. I run a query and sort by one of the column in "datasheet view" mode
(Records / Sort Asc. resp. Desc.)
3. Saved the query

The query was saved with the sort option set by the Access not the SQL...

Thank you again for the information....

Hi Richard,

Is there a chance that when you were viewing
the results of your query, you applied a sort on
one of the columns?

To test if this is the case, run the query, and while
viewing the results, click on Records/Remove Filter/Sort
in top menu. Does the "repeat" go away?

If you need to sort your results, it is best to do it in
the Design View using the Sort row.

Please respond back if I have misunderstood
or was not clear about something.

Good luck,

Gary Walter

I have a question which seems just to be a matter of that I am an ACCESS-novice and

doesnj't have to be considered a real problem...

I found this trying out Date formatting functions - Format() and DatePart.

I have a query where the first column is [Datum] + group by, the second is

Format([Datum]) returning week number and the third is DatePart([Datum]).

For first column is a criterion set 'Between [from] and [to]'.

When I run the query a pop-up window appear:

Enter parameter value [from]
Enter parameter value [to]

....no problem. But afterwards again these pop-ups appear once again.

Can anybody explain me why? Thanks in advance.

I have a report based on a query with a prompt for my
parameter query: >=[Enter date of first transaction].

When the report compiles, the query prompt is displayed as
each page is compiled, so for a 16 page report, I have to
input the transaction date 16 times.

THEN, when I go to print the report, I am again prompted
for the same parameter info.

Suggestions?

Thanks.
BTW, when just the query is run, I do not have this
problem.