Access 2007 Sorting problem

  theearlofsabden 01:59 04 Nov 08
Locked

Hi all.

Linking my database to a mail merge - not a problem.

I have several columns in the database, I need two of the columns to sort A-Z.

If I sort one column A-Z and then do the other, it reverts back to the previous sort.

Column 1 contains A-Z of company names
Column 2 contains a list of first names
Column 3 contains a list of surnames
Column 4 contains a list of addresses

Column 1 must stay the same, A-Z of company names.
I need Column 3 to list surnames in A-Z ... BUT not affect the A-Z of Column 1.

Any ideas?

Thanks
Neil.

  fitshase 18:35 05 Nov 08

You would need to set up a query in the database to query your database (say, show all records) then sort the results by the Company name (ascending) then the Surname (ascending).

Now, link your mail merge document to the query instead of the table.

The query will show the table sorted by the Company name first (A-Z) then the Surname (A-Z).

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…