how to sort in access without defaulting to the primary key

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do i keep from defaulting to the primary key within a nested sort.

Thank you very much.

Lance
 
This is a reports news group. The method used to reliably sort records in a
report is to use the Sorting and Grouping dialog.
 
Thank you for your response. I am using the Sorting & Grouping Dialog. It is
a little complicated. I have a db set up with each record having a primary
key. I want to sort by Head of Household, sequence member within family, and
in alphabetical order by last name, without the entire listing defaulting to
being in order by the primary key. When I create the record with this sort
criteria it puts the list in order by primary key rather than last name.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Access Avoiding redundancy 1
building a complicated (to me) string 4
Grouping without a primary key 1
Access Access Record Order 0
Report based on query with Primary Key 1
Clone an operating system 10
Why won't Access assign a Primary Key ID to my linked SQL Table? 2
Reports that sift records from different tables 0

Back
Top