Null exported as zero

M

MEdmonds

I have a mail merge in Word that gets data from an Access 2002 query. Fields
that are blank (null) in Access are showing as zero in Word after the mail
merge. I exported the query results to Excel and ran the merge using the
Excel spreadsheet, and the zeros did not appear, so it seems to be happening
only when exporting from Access directly. Based on some quick tests, this
problem doesn't happen when using Access 2003, only when using Access 2002.
I'm a beginner, so any help would be appreciated. Thanks.
 

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