|
| 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
October 5th, 2005, 04:20 PM
|
|||
|
|||
sorting data in a report
In some of my reports, I am unable to get the "Client name" field to sort
alphabetically in spite of having specified this when ceating the report through a wizard and also sorting the field in the query on which the report is based. The report always sorts according to the client code which is numerical, even if the client code does not appear anywhere in the query. The "client name" field is a lookup in the original table. Can anyone help ? Many thanks, David S 
|
|
#2
October 5th, 2005, 04:57 PM
|
|||
|
|||
|
Go design view and click on the Grouping and Sorting button on the toobar at
the top of the scree. Set sorting here. -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "David" wrote in message ... In some of my reports, I am unable to get the "Client name" field to sort alphabetically in spite of having specified this when ceating the report through a wizard and also sorting the field in the query on which the report is based. The report always sorts according to the client code which is numerical, even if the client code does not appear anywhere in the query. The "client name" field is a lookup in the original table. Can anyone help ? Many thanks, David S
|
|
#3
October 5th, 2005, 05:46 PM
|
|||
|
|||
|
Thanks PC but I've tried that and it's set correctly to "Client name" but
still sorts according to the client code number "PC Datasheet" wrote: Go design view and click on the Grouping and Sorting button on the toobar at the top of the scree. Set sorting here. -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "David" wrote in message ... In some of my reports, I am unable to get the "Client name" field to sort alphabetically in spite of having specified this when ceating the report through a wizard and also sorting the field in the query on which the report is based. The report always sorts according to the client code which is numerical, even if the client code does not appear anywhere in the query. The "client name" field is a lookup in the original table. Can anyone help ? Many thanks, David S
|
|
#4
October 5th, 2005, 05:48 PM
|
|||
|
|||
|
David wrote:
In some of my reports, I am unable to get the "Client name" field to sort alphabetically in spite of having specified this when ceating the report through a wizard and also sorting the field in the query on which the report is based. The report always sorts according to the client code which is numerical, even if the client code does not appear anywhere in the query. The "client name" field is a lookup in the original table. THe only reliable way to sort a report is to specify the sorting field(s?) or expressions using the Sorting and Grouping window (View menu). -- Marsh MVP [MS Access]
|
|
#5
October 5th, 2005, 06:01 PM
|
|||
|
|||
|
"Marshall Barton" wrote: David wrote: In some of my reports, I am unable to get the "Client name" field to sort alphabetically in spite of having specified this when ceating the report through a wizard and also sorting the field in the query on which the report is based. The report always sorts according to the client code which is numerical, even if the client code does not appear anywhere in the query. The "client name" field is a lookup in the original table. THe only reliable way to sort a report is to specify the sorting field(s?) or expressions using the Sorting and Grouping window (View menu). -- Marsh MVP [MS Access] Tbnaks but this doens't help
|
|
#6
October 5th, 2005, 07:40 PM
|
|||
|
|||
|
Don't use lookup fields. Make sure the "looked up" table is in your report's
record source so that you can add the "real" field with the "real" value into your report for sorting. I expect you might have also used the caption property of the field in the table design to hide the real field name. -- Duane Hookom MS Access MVP "David" wrote in message ... "Marshall Barton" wrote: David wrote: In some of my reports, I am unable to get the "Client name" field to sort alphabetically in spite of having specified this when ceating the report through a wizard and also sorting the field in the query on which the report is based. The report always sorts according to the client code which is numerical, even if the client code does not appear anywhere in the query. The "client name" field is a lookup in the original table. THe only reliable way to sort a report is to specify the sorting field(s?) or expressions using the Sorting and Grouping window (View menu). -- Marsh MVP [MS Access] Tbnaks but this doens't help
|
|
#7
October 5th, 2005, 10:18 PM
|
|||
|
|||
|
Two suggestions:
1) If the report is based on a query, make sure the Client name field is the first one in the query, 2) Check to see that Sorting and Grouping in the report has the Client name in the first row. Quote:
|
|
#8
October 6th, 2005, 08:23 AM
|
|||
|
|||
|
Thanks for the ideas. I made a mistake in my original post, the field is not
a lookup, apologies. I am using the correct field name and the queryt on which the report is based has "Client name" first with the query results sorted in alphabetical order, it's just the report bawed on the query sorts according to the client code, not alphbetically. I don't always have this problem with other reports, some sort aplhbetically, some by code. It's most frustrating as I can't see why ! "jahoobob" wrote: Two suggestions: 1) If the report is based on a query, make sure the Client name field is the first one in the query, 2) Check to see that Sorting and Grouping in the report has the Client name in the first row. David Wrote: In some of my reports, I am unable to get the "Client name" field to sort alphabetically in spite of having specified this when ceating the report through a wizard and also sorting the field in the query on which the report is based. The report always sorts according to the client code which is numerical, even if the client code does not appear anywhere in the query. The "client name" field is a lookup in the original table. Can anyone help ? Many thanks, David S -- jahoobob
|
|
#9
October 6th, 2005, 02:48 PM
|
|||
|
|||
|
You are referring to sorting in a report. Several replies suggest the
sorting in the query is worthless and you need to sort in the report design. Yet, you reply back "query results sorted in alphabetical order" and "query sorts according to the client code". Did you attempt to sort your report using the sorting and grouping dialog in the report? What are all of the Sorting and Grouping expressions/fields in the dialog? -- Duane Hookom MS Access MVP -- "David" wrote in message ... Thanks for the ideas. I made a mistake in my original post, the field is not a lookup, apologies. I am using the correct field name and the queryt on which the report is based has "Client name" first with the query results sorted in alphabetical order, it's just the report bawed on the query sorts according to the client code, not alphbetically. I don't always have this problem with other reports, some sort aplhbetically, some by code. It's most frustrating as I can't see why ! "jahoobob" wrote: Two suggestions: 1) If the report is based on a query, make sure the Client name field is the first one in the query, 2) Check to see that Sorting and Grouping in the report has the Client name in the first row. David Wrote: In some of my reports, I am unable to get the "Client name" field to sort alphabetically in spite of having specified this when ceating the report through a wizard and also sorting the field in the query on which the report is based. The report always sorts according to the client code which is numerical, even if the client code does not appear anywhere in the query. The "client name" field is a lookup in the original table. Can anyone help ? Many thanks, David S -- jahoobob
|
|
#10
October 6th, 2005, 03:15 PM
|
|||
|
|||
|
Hi Duane,
The query on which the report is based has "client name" sorted alaphabetically. When I run the report, the client name field is sorted according to the client name numeric code which is the unique ID on the client details form but it not a field in the query. When I set up the report via a wizard, I specified that the client name be sorted alphabetically. When I check the report in design view, the sorting/grouping expression is correct, just the one which is "client name". It must be because of the ID but this does not happen in every report which contains "client name" as a field. Thanks for your time. David "Duane Hookom" wrote: You are referring to sorting in a report. Several replies suggest the sorting in the query is worthless and you need to sort in the report design. Yet, you reply back "query results sorted in alphabetical order" and "query sorts according to the client code". Did you attempt to sort your report using the sorting and grouping dialog in the report? What are all of the Sorting and Grouping expressions/fields in the dialog? -- Duane Hookom MS Access MVP -- "David" wrote in message ... Thanks for the ideas. I made a mistake in my original post, the field is not a lookup, apologies. I am using the correct field name and the queryt on which the report is based has "Client name" first with the query results sorted in alphabetical order, it's just the report bawed on the query sorts according to the client code, not alphbetically. I don't always have this problem with other reports, some sort aplhbetically, some by code. It's most frustrating as I can't see why ! "jahoobob" wrote: Two suggestions: 1) If the report is based on a query, make sure the Client name field is the first one in the query, 2) Check to see that Sorting and Grouping in the report has the Client name in the first row. David Wrote: In some of my reports, I am unable to get the "Client name" field to sort alphabetically in spite of having specified this when ceating the report through a wizard and also sorting the field in the query on which the report is based. The report always sorts according to the client code which is numerical, even if the client code does not appear anywhere in the query. The "client name" field is a lookup in the original table. Can anyone help ? Many thanks, David S -- jahoobob
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Sort pages? | David | General Discussion | 15 | May 13th, 2005 11:33 PM |
| Data on report based on current date | JenniferM | Setting Up & Running Reports | 4 | April 18th, 2005 10:45 PM |
| SQL view of messed up action queries | Kendra | Running & Setting Up Queries | 2 | August 31st, 2004 09:53 PM |
| Display Parameter from Form on Report | sara | Setting Up & Running Reports | 10 | July 19th, 2004 04:54 PM |
| How to create graphs in a monthly report where the base data can change | John Clarke | Charts and Charting | 3 | June 25th, 2004 02:22 AM |
Linear Mode
