Re: sorting a mail merge

From: Albert D. Kallal (pleasenonosspammkallal_at_msn.com)
Date: 02/20/04 

Date: Fri, 20 Feb 2004 21:55:14 GMT

Simply create a query of the data in the ms-access side. You then set the
sort of that query also.

Then, when you do the mail merge..use that query and NOT the table.

In fact, for your forms, listboxes, combo boxes you should use a query if
you need to set a sort order. The only exception to this is when you make a
report...as it has its own settings for the sort order..and the table, or
query order is ignored.

Also, if you want a nice example of a ms-access to word merge...check out my
sample at:

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html 

--
Albert D. Kallal        (MVP)
Edmonton, Alberta Canada
pleasenonoSpamKallal@msn.com
http://www.attcanada.net/~kallal.msn

Relevant Pages

  • Re: Make Table Query - Sorting Errors
    ... Dim OutputTable As DAO.Recordset ... The query to concatenate the CAMPNO values will need to be LOOKING at the ... If you post the query you are using to do this, I beleive we can get it to ... Is there a command that I can use in the module code to first sort the ...
    (microsoft.public.access.queries)
  • Re: Make Table Query - Sorting Errors
    ... You sort in a query, ... You can do a compound sort in a query. ... "Tom Ellison" wrote: ... resulting table only has one record for each value of "CAMPNO". ...
    (microsoft.public.access.queries)
  • Re: Query doesnt always sort
    ... You have to use a query to sort the data in to your required order and then ... Access MVP 2002-2005, 2007 ... University of Maryland Baltimore County ... How do I impose a sort on the datasheet view? ...
    (microsoft.public.access.queries)
  • Re: Make Table Query - Sorting Errors
    ... MS Access MVP ... resulting table only has one record for each value of "CAMPNO". ... Is there a command that I can use in the module code to first sort the ... I have a make table query that is supposed to sort in ascending order ...
    (microsoft.public.access.queries)
  • Re: Forms datasheet view - sort order problem
    ... > I have a query which have several columns. ... > So in the datasheet view, the data are sort in the desired order. ... > The original sort order is over-rided and cannot be reversed. ... > last sorting order, i.e, the unwanted one. ...
    (microsoft.public.access.forms)