Access 2007 - Record Sorting

[Risikio]

I am trying to print labels from an access 2007 database sorted by the zip
code. In my query, I have the zip code sorted ascending and placed as the
very first column in the design view of the query. However, when I run my
report which I have set up to print out like a sheet of labels, the zip code
sort does not hold. Instead, the report is sorted alphabetically by the
individual's last name. I have search all through the property settings and
can not find where the problem is. This is one of the first times I have
used 2007 (I recently upgraded from 2003), and so I wonder if it might have
something to do with 2007 vs. 2003.

Thanks.

 

[Douglas J. Steele]

Reports do not respect the order of the records in the incoming recordset.
You need to use the Sorting and Grouping dialog within the report builder.
(It was this way in Access 2003 as well)

 

[strive4peace]

from the report design, click on the Design tab in the ribbon and then
the 'Group and Sort' icon.

You will see the sorting and grouping levels at the bottom of the screen
-- you can define them by clicking on the 'Add a Group' or 'Add a Sort'
button

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*

 

[MikeJohnB]

The sorting order in reports is independant of queries or form layouts and
has been for Access 2003 and 2000 as far as I know.

With your report in design view, select Group and Sort from the Design
Ribbon, click add a sort on the popup window at the bottom of the screen.
drag the field Zip Code from the field list to the sort window.

I hope this helps???? Please let me know if you find the solution?

Kindest regards
Mike B

 

[a a r o n _ k e m p f]

Doug;

So sorry that your Jet database isn't reliable enough.

With SQL Server, you have real row ordering-- build a clustered index
on a field, and queries (against that field) are much faster

So sorry that you don't have the same power with Jet.
Maybe you should move to a database with a future

I just think that it's funny.. that you take your 'JET BUG' and you
try to apply it to the whole database industry.

-Aaron

 

[Aaron Kempf knows nothing]

So sorry that a a r o n _ k e m p f isn't reliable enough.


So sorry that a a r o n don't have the same power.
Maybe I should move to a life with a future

 

[Douglas J. Steele]

Your comments, as usual, have absolutely no bearing on the issue at hand.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Doug;

So sorry that your Jet database isn't reliable enough.

With SQL Server, you have real row ordering-- build a clustered index
on a field, and queries (against that field) are much faster

So sorry that you don't have the same power with Jet.
Maybe you should move to a database with a future

I just think that it's funny.. that you take your 'JET BUG' and you
try to apply it to the whole database industry.

-Aaron

 

[Risikio]

Thanks everybody. I got my report to sort correctly. I apologize for
overlooking the sorting and grouping section. I should have known that.

 

[strive4peace]

you're welcome, Risikio

no need to apologize, that is why we are here ...

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*