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
|
|||
|
|||
Sorting a report
I am self taught in MS Access 2000 and am at a really basic level. I have a
report that will not give me all my records unless I sort starting with the GiverID (the unique identifier.) However, even adding a second level sort on LastName and a third on FirstName, I cannot get the report to come out alphabetically by last name. It comes out GiverID ascending. Unless I sort by GiverID first, it gives me only the first occurence it comes to of records of those with the same last name, but a different first name. I have about zero understanding of SQL and have gleaned most of what's in my underlying query from examples posted in forums on the web. I tried using OrderBy, but that doesn't work. I'm sure it's something very simple, but I can't figure it out. Thanks for your help. -- Learning as I go... |
#2
|
|||
|
|||
Sorting a report
On Sun, 31 Jan 2010 07:15:01 -0800, denden wrote:
I am self taught in MS Access 2000 and am at a really basic level. I have a report that will not give me all my records unless I sort starting with the GiverID (the unique identifier.) However, even adding a second level sort on LastName and a third on FirstName, I cannot get the report to come out alphabetically by last name. It comes out GiverID ascending. Unless I sort by GiverID first, it gives me only the first occurence it comes to of records of those with the same last name, but a different first name. I have about zero understanding of SQL and have gleaned most of what's in my underlying query from examples posted in forums on the web. I tried using OrderBy, but that doesn't work. I'm sure it's something very simple, but I can't figure it out. Thanks for your help. I suspect ('I have about zero understanding of SQL') that you are sorting the records in the query. Any sort in the query is irrelevant in 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
|
|||
|
|||
Sorting a report
The report's group levels need to be the other way round. The first group
level is LastName, the second FirstName, the third GiverID. That will sort the report by name. If you want to group the report by each person give the GiverID group level a group header, not the first or last name groups, and include the first and last name controls in the GiverID group header. This will then separate out any two or more people with the same names; which does happen - I worked with two Maggie Taylors. As Fred said, don't sort the query. It serves no purpose as the report ignores it and merely slows it down. Ken Sheridan Stafford, England denden wrote: I am self taught in MS Access 2000 and am at a really basic level. I have a report that will not give me all my records unless I sort starting with the GiverID (the unique identifier.) However, even adding a second level sort on LastName and a third on FirstName, I cannot get the report to come out alphabetically by last name. It comes out GiverID ascending. Unless I sort by GiverID first, it gives me only the first occurence it comes to of records of those with the same last name, but a different first name. I have about zero understanding of SQL and have gleaned most of what's in my underlying query from examples posted in forums on the web. I tried using OrderBy, but that doesn't work. I'm sure it's something very simple, but I can't figure it out. Thanks for your help. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/201001/1 |
Thread Tools | |
Display Modes | |
|
|