Prev: time and colums
Next: Deleting Data in Sample database Northwind traders
From: denden on 31 Jan 2010 10:15
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...
From: fredg on 31 Jan 2010 12:46
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
From: KenSheridan via AccessMonster.com on 31 Jan 2010 19:14
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/Forums.aspx/access-gettingstarted/201001/1

 | 
Pages: 1
Prev: time and colums
Next: Deleting Data in Sample database Northwind traders