If/Else sql for query or report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Linda Keltner - 19 Oct 2004 20:01 GMT

I have a data base of group officers. Some have appointed a representative
to a consortium, some have not. I want to print a report that lists the
groups with their representative AND if no rep. has been appointed, print the
Vice-President of the group instead.

Is this possible? I either get only the rep or both the rep and the vp
together .

Thank you.
Linda

Reply to this Message

Marshall Barton - 19 Oct 2004 21:14 GMT

"Linda Keltner" <Linda Keltner@discussions.microsoft.com>
wrote:

>I have a data base of group officers. Some have appointed a representative
>to a consortium, some have not. I want to print a report that lists the
>groups with their representative AND if no rep. has been appointed, print the
>Vice-President of the group instead.

Use an expression in the text box to test if the rep is not
there:

=IIf([rep] Is Null, <whatever to get vp>, [rep])

Signature

Marsh
MVP [MS Access]

Reply to this Message