|
| 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
February 23rd, 2010, 11:47 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
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
February 23rd, 2010, 11:52 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
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
February 24th, 2010, 12:14 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
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
February 24th, 2010, 12:26 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
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
February 24th, 2010, 12:56 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
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
February 24th, 2010, 01:20 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
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
February 24th, 2010, 02:12 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
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 | |
|
|
Linear Mode
