Merging-data not staying in order

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

Guest

Hi, I am merging from a query onto envelopes in word. The data on the
envelopes is coming out in the wrong order. Its really important that I fix
it as I am doing a mail out to the 2000 contacts in our database! Does
anyone know why this wouldn't be staying in order?
 
Do you have an ORDER BY Clause in the Query?

If you need to sort the rows / Records, you need to specify the sorting in
the Query rather than leaving Access to do "default" sort ...
 
The information in the query is in the right order, but when I merge it it
goes into a random order.
--
Thanks for taking the time to read this, hope you can help me!

Leabee1


Van T. Dinh said:
Do you have an ORDER BY Clause in the Query?

If you need to sort the rows / Records, you need to specify the sorting in
the Query rather than leaving Access to do "default" sort ...
Click to expand...
 
Let me ask the question again: Do you have the ORDER By clause in your
Query?

If you don't, then Access GUI may, by coincidence, have the correct sorting
(usually according to the PK) but when Access/JET passes the data to Word,
it may pass the data in the order of retrieval.

The ONLY way to ensure the Records are sorted the way you want is to include
an ORDER BY clause in your Query!
 
Back
Top