If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Problem with report
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? -- Lenee |
#2
|
|||
|
|||
Problem with report
On Tue, 23 Feb 2010 15:47:01 -0800, Lenee wrote:
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. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#3
|
|||
|
|||
Problem with report
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." "Lenee" wrote in message ... 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? -- Lenee |
#4
|
|||
|
|||
Problem with report
You have to use the report internal grouping and sorting as it ignores the
sorting done in a query. -- Build a little, test a little. "Lenee" wrote: 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? -- Lenee |
#5
|
|||
|
|||
Problem with report
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? -- Lenee "Al Campagna" wrote: 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." "Lenee" wrote in message ... 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? -- Lenee . |
#6
|
|||
|
|||
Problem with report
Lenee,
Will the report follow the criteria from the query? 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" wrote in message ... 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? -- Lenee "Al Campagna" wrote: 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." "Lenee" wrote in message ... 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? -- Lenee . |
#7
|
|||
|
|||
Problem with report
Al,
Thanks it is working great. -- Lenee "Al Campagna" wrote: Lenee, Will the report follow the criteria from the query? 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" wrote in message ... 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? -- Lenee "Al Campagna" wrote: 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." "Lenee" wrote in message ... 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? -- Lenee . . |
Thread Tools | |
Display Modes | |
|
|