True or False Print display

[Avick]

I am trying to get a label report to print out a (P) or (F) on a label biased on the criteria True or False.

I have a database that print’s labels for members in a club. Most members are paying members but there are some members that are free for a number of reasons.

We need to identify the free members by the label that is printed on the envelop.
These members do not get inserts in there mail shots.

In the database I have a field called mem_free if this is checked the answer is yes. If its not the answer is no.

My labels print like so:

Memno
Name
Address1
Address2
Address3

I would like it to look like this

Memno P
Name
Address1
Address2
Address3


I think it’s the if statement but I can’t remember how the format will go.

if(mem_fee=yes then print “F”)

Everything else would be P

 

[ColinEssex]

use an IIF statement

Col

 

[Avick]

Tried that with no joy.

I have

iif([mem_free]="yes","F","P")

It won't pick up the information and all records are printing P

 

[Spidey]

How about a Solid Box?

I am trying to do something similar. I would like to show a solid box instead of a check mark when the condition is true. I think it kind of ties in to the topic at hand so any help would be appreciated.

 

[ColinEssex]

IIf([mem_free] = -1,"F","P")

Col

 

[Avick]

Thanks Col

Worked perfect