I hate to bother you, but the word documents are still sorting acording to
the record number, and not the order in which i sorted the query.

Thanks
Dave

"Doug Robbins" wrote:

Use a select Query in Access in which you set the sort order for the
appropriate field. Then use that query as the datasource.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"geisi" wrote in message
...

New Question
i have over 200 records, how can i sort them alphabetically after i sort
them?
(the records are added one at a time, so the record numbers are not sorted
a-z)

Thanks
Dave

"geisi" wrote:

Thnak you very much, that worked great!

Dave

"Doug Robbins" wrote:

To start off with, put A and B as the results, then use Alt+F9 to
toggle on
the display of field codes and replace the A and B with the respective
symbols.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"geisi" wrote in message
...
thanks for the quick response.
I still have the problom, b/c the window does not allow me to insert
any
symbols in the proper place. (i can only input the keys that are on
the
keyboard)

Dave

"Doug Robbins" wrote:

Use an If...then...Else field to insert the appropriate symbol from
the
Insert Symbols dialog depending upon a check of the value in the
mergefield.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of
my
services on a paid consulting basis.

Doug Robbins - Word MVP
"geisi" wrote in message
...
when i merge a check box, i see the results as either -1 or 0
insted of
a
checked box or unchecked box, how do i correct this?

"Doug Robbins - Word MVP" wrote:

In Word, from the Tools Menu, selection Options and then on the
General
tab,
check the Confirm conversions on Open box and when you connect to
the
data
source, select the DDE method of connection.

--
Please post any further questions or followup to the newsgroups
for
the
benefit of others who may be interested. Unsolicited questions
forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
"rbuzzell" wrote in message
...
I recently upgraded from Office 97 to Office 2002. I have a
large
Access
database which serves as a data source for several Word mail
merge
programs
to generate reports. Some of the data fields use a form check
box
(YES/NO)
control which are not merging correctly in If... Then... Else...
merge
fields. It worked in the 97 version using "Yes" = -1 and "No" =
0
(...I
think). Since upgrading however, these merge fields no longer
work.
In
version 2002, how do I configu If mergefield is equal to
(check
box
control field checked) "type this sentence" ""?

Thanks for any help,
rbuzzell