Mail Merge Query Question

[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

 

[KARL DEWEY]

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.

 

[Dave]

Wow that was quick!
Thanks Karl
David

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

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