View Single Post
  #6  
Old May 21st, 2010, 01:14 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default parameter prompt

mal moores wrote:

This thread saved my sanity!

I had a union query based on a number of other queries, all ran fine and returned the correct data.
My form and subform showed all the correct data and functioned perfectly.

When I ran the report based on the same query and the data I could see on screen I got the dreaded parameter prompt!!!

Although the above pointed to the report being the problem I even ended up rewriting the queries etc.
After two days and a lot of ~#~~~#**~~~ etc. I found this thread :0) thank god!!!
Two minutes later all working fine no parameter prompt.

SOLUTION:
Very last line on the screen in grouping/sorting was the word "Expression"? I clicked and expanded and there it was the **##***#~~~*!!!!! sort on "ATRecyID" I couldn't even remember adding this line, my data was sorted in the queries it wasn't required - deleated and away we go, perfect.

To be honest it should have been "NRRecyID" but it wasn't needed!

Hope this may help your sanity!

AB to the rescue again :0)



That may work in your report, but it may not work if you
change your report or use the same approach in another
report. The reason I say that is because sorting a report's
record source query is only effective if the report has
nothing in its Sorting and Grouping. As soon as you put
anything in Sorting and Grouping, it takes precedence over
sorting in the query. In general, sorting a report's record
source query is a waste of resources and Sorting and
Grouping should always be used.

--
Marsh
MVP [MS Access]