Report problem

[TheRiver]

I have a report craeted using a table. One of the fields in the table holds data that can either me a 1 or a 2.
1 = Male, 2 = Female.

I pull these ones and twos across onto the report. Is there any way of changing the ones and twos in the control source so that the report shows male or female????

 

[PaulBricker]

Add an unbound textbox to the report and set the control source to
=IIf([FieldName] = 1,"Male","Female&quot

 

[TheRiver]

I do this and the report just shows "#ERROR#"

 

[PaulBricker]

What is the name of your field that has the 1 and 2 in it?

Paul

 

[TheRiver]

Int_Man

 

[PaulBricker]

Then in the Control Source for a textbox you should have
=IIf([Int_Man] = 1,"Male","Female&quot

If Int_Man is part of the Record Source then this expression should work.

Paul

 

[TheRiver]

That's what I got, but not working?

 

[PaulBricker]

That is a mystery then. I'm not sure what the problem is. If you just add a control with the Control Source set to Int_Man, what values are displayed in the Report?

Paul

 

[TheRiver]

#ERROR

 

[PaulBricker]

Well that means that something in the Record Source for the Report isn't correct. Is the record source set to a query? If it is can you post the SQL for the query here.

Paul

 

[TheRiver]

No the record source is from a table.

 

[TheRiver]

I don't know what is causing this as if I change the field name from Int_Man to Int then it works fine. THe only problem is I want to use Int_Man as the fieldname.

 

[PaulBricker]

I'm not sure what the name of a field would have to do with this whole thing. It doesn't make any sense to me. What is the datatype of the field? Text, Number? That might make a difference. Also, is it a lookup field by some chance.

Paul