Re: Adding a filter to a report

Use the expression I posted in an empty Column of the Query Design grid.

If you open the Datasheet of the Query, this Column will show Mr or Miss
depending on the gender of the kid.

KidTitle is called a Caluculated Field since it is calculated / derived from
other values. In your Reports / Labels, you can use the Calculated Fields
just like other Fields.

--
HTH
Van T. Dinh
MVP (Access)




"David G" <drgibson@xxxxxxxxxxxxxx> wrote in message
news:CEyle.50179$fx3.17379@xxxxxxxxxxxxx
> I got the gender select thing to work on the roster, very cool. I
> couldn't figure out the label thing so I added another field for "Title"
> and made it a combo list box to select either Mr. or Miss. Then I went
> through all the kids and assigned a title. I just couldn't figure out
> the calulated field of
> KidTitle: IIf( [SEX] = "M", "Mr", IIf( [SEX] = "F", "Miss", "" ) )
> The help section didn't make it clear enough for me.
> David
>


.