Problem with report

  • Thread starter Thread starter Lenee
  • Start date Start date
L

Lenee

I have built a query that is sorted by last name and when I hit run it works.
When I put it in the control source of a report it doesn't sort it correctly.
What am I missing or doing wrong?
 
I have built a query that is sorted by last name and when I hit run it works.
When I put it in the control source of a report it doesn't sort it correctly.
What am I missing or doing wrong?
Click to expand...

Do you mean the report doesn't sort the same as the query.

The sort order of a query is irrelevant to the sort order of a report.
To sort a report, use the report's sorting and grouping dialog.
In Report design view click on View + Sorting and Grouping.
 
Lenee,
Report Sorting on reports is controlled by the Sorting & Grouping
dialog box in report design mode... not by the sorting of the table or query
behind the report.
In design mode, use View/Sorting & Grouping, and set up your sorting in
the dialog box.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
You have to use the report internal grouping and sorting as it ignores the
sorting done in a query.
 
Thanks everyone!! This worked wonderfully. I feel like an idiot, glad it was
something so simple. Will the report follow the criteria from the query?
 
Back
Top