Problem with report

[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?

 

[fredg]

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?

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.

 

[Al Campagna]

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."

 

[KARL DEWEY]

You have to use the report internal grouping and sorting as it ignores the
sorting done in a query.

 

[Lenee]

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?

 

[Al Campagna]

Lenee,Yesy... it will still obey the criteria you set for it.
--
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."

 

[Lenee]

Al,
Thanks it is working great.
--
Lenee

Lenee,
Yesy... it will still obey the criteria you set for it.
--
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."




.