Some Mail Merges dont work?

S

Steve

Hi,

We are having a problem with exporting queries to Mail Merge.

This is in Access 2002/2003

We have a pretty simple-minded database upon which we run some queries and
generate form letters.

Recently we have made some queries that do not export properly.
That is, when we get to the form letter in Word, the recipient list is
empty.

Stored queries that worked before still work. The recipient list in Word is
not empty.

The only common item we can discern among the failing queries is the
use of Like "*/07" to select all the records of the type 01/07, 02/07 and so
on up to 12/07.

Other wildcard queries with something such as Like "0[1-7]/07" do export
successfully.

We're baffled. What can cause the data to disappear on the way into Word
like this?

Steve
 
W

Wolfgang Kais

Hello Steve.

Steve said:
We are having a problem with exporting queries to Mail Merge.

This is in Access 2002/2003

We have a pretty simple-minded database upon which we run some
queries and generate form letters.

Recently we have made some queries that do not export properly.
That is, when we get to the form letter in Word, the recipient
list is empty.

Stored queries that worked before still work. The recipient list
in Word is not empty.

The only common item we can discern among the failing queries is
the use of Like "*/07" to select all the records of the type 01/07,
02/07 and so on up to 12/07.

Other wildcard queries with something such as Like "0[1-7]/07"
do export successfully.

We're baffled. What can cause the data to disappear on the way
into Word like this?

Depending on how Word accesses the Access database, different
wildcard characters are used. Try this: Like "%/07".
 
J

John W. Vinson

Hi,

We are having a problem with exporting queries to Mail Merge.

This is in Access 2002/2003

We have a pretty simple-minded database upon which we run some queries and
generate form letters.

Recently we have made some queries that do not export properly.
That is, when we get to the form letter in Word, the recipient list is
empty.

Stored queries that worked before still work. The recipient list in Word is
not empty.

The only common item we can discern among the failing queries is the
use of Like "*/07" to select all the records of the type 01/07, 02/07 and so
on up to 12/07.

Other wildcard queries with something such as Like "0[1-7]/07" do export
successfully.

We're baffled. What can cause the data to disappear on the way into Word
like this?

Steve

If you're searching a Date/Time field, you should realize that it is NOT
stored as a text string. A Date is actually stored as a double float number, a
count of days and fractions of a day (times) since midnight, December 30,
1899. You're not exporting a text string "03/07" - you're exporting a Date,
which Access and/or Word will *display* as a text string.

If you are in fact storing "12/07" in a Text string then my concern is
misplaced and I apologize.
 
S

Steve

John W. Vinson said:
[]>>

If you're searching a Date/Time field, you should realize that it is NOT
stored as a text string. A Date is actually stored as a double float
number, a
count of days and fractions of a day (times) since midnight, December 30,
1899. You're not exporting a text string "03/07" - you're exporting a
Date,
which Access and/or Word will *display* as a text string.

If you are in fact storing "12/07" in a Text string then my concern is
misplaced and I apologize.

Thanks. That's good advice. In this case the field is stored as text. The DB
was put together by someone who was mostly ignorant of databases. It's
now in the hands of someone not much better. :)

Steve
 
S

Steve

Wolfgang Kais said:
Hello Steve.

Steve said:
We are having a problem with exporting queries to Mail Merge.
[]>
Depending on how Word accesses the Access database, different
wildcard characters are used. Try this: Like "%/07".
Thank you! This did the trick.

Steve
 

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

Top