If/Else sql for query or report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
Click to expand...

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

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