Mail Merge Query Question

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Hi All,

I work for a small UK charity and we have an Access 2003 database with
addresses and tick boxes recording whether people in the database want
information on various services (Eg fire safety check, benefits info). I
want to be able to print out a letter to send to people in the database who
have requested information on these various services but each letter will be
different.

I was going to store standard paragraphs in fields in an access table then
use mail merge with word to print out a customised form letter with
paragraphs automatically added depending on what info was requested.

Trouble is I cant work out what query I need as it would have to say 'IF
field A is 'YES' THEN print out field X in Table B etc. Can I do this in a
single query? Is there a better way of approaching the problem?

Cheers, David
 
Trouble is I cant work out what query I need as it would have to say 'IF
field A is 'YES' THEN print out field X in Table B etc.
Use a calculated field like this ---
Para_Q: IIF([Table A].[Field A] = "Yes", [Table B].[Field X], [Table
B].[Field Y])
If you need more choices then nest your IIF statements.
 
Wow that was quick!
Thanks Karl
David

KARL DEWEY said:
field A is 'YES' THEN print out field X in Table B etc.
Use a calculated field like this ---
Para_Q: IIF([Table A].[Field A] = "Yes", [Table B].[Field X], [Table
B].[Field Y])
If you need more choices then nest your IIF statements.
--
KARL DEWEY
Build a little - Test a little


Dave said:
Hi All,

I work for a small UK charity and we have an Access 2003 database with
addresses and tick boxes recording whether people in the database want
information on various services (Eg fire safety check, benefits info). I
want to be able to print out a letter to send to people in the database
who
have requested information on these various services but each letter will
be
different.

I was going to store standard paragraphs in fields in an access table
then
use mail merge with word to print out a customised form letter with
paragraphs automatically added depending on what info was requested.

Trouble is I cant work out what query I need as it would have to say 'IF
field A is 'YES' THEN print out field X in Table B etc. Can I do this in
a
single query? Is there a better way of approaching the problem?

Cheers, David
Click to expand...
Click to expand...
 
Back
Top