Sorting a report

[denden]

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.

 

[fredg]

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.