Some Mail Merges dont work?

[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

 

[Wolfgang Kais]

Hello Steve.

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".

 

[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.

 

[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.

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

 

[Steve]

Hello Steve.

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