Database linked with Office, field query.

Spacky · 18 Jul 2006 at 12:23

I work with a database that is an MS Access nasty, I have it generate letters from its databse via the mail merge utility in word.

However there is one field (gender) that outputs the gender into office as M or F, now since these are letters is there a way other than Find and Replace. Where I can change the F to Ms and the M to Mr. I can't tweak or poke the databse mind.

Any help appreciated possibly a macro but no idea really what I am hoping for.

TrUz · 18 Jul 2006 at 12:42

Changing the Database would be the best. But what if the Ms in question is not a Ms and she is a Miss or Mrs? Sticking with M or F would be better than addressing someone incorrectly.

TrUz

A[L]C · 18 Jul 2006 at 12:58

TrUz said:
Changing the Database would be the best. But what if the Ms in question is not a Ms and she is a Miss or Mrs? Sticking with M or F would be better than addressing someone incorrectly.

TrUz

I thought Ms was a generic for when you dont know if they are Mrs or Miss?

Spacky · 18 Jul 2006 at 14:24

We use Ms and Mr, the database doesn't handle titles. So I have to base it on Gender, thats mail merge with access for you.