Compile Error while trying to create a report from a query

[Kelsod]

I was trying to create a report from a query to try and make an invoice. I just wanted to pull all the data from the query and then I was going to design it, but I got the following error "Compile Error IIf(IsNumeric(tblsStyleName),ApploadString(tblStyl e.StyleName),tblStyles.StyleName'." How do I fix it?

[rzw0wr]

IIf(IsNumeric(tblsStyleName),ApploadString(tblStyl e.StyleName),tblStyles.StyleName

Why would you put this in a query.
You should know if the field is numeric by the type.

Please tell us what you want to do and maybe we can find a way that is better.

Dale

[Kelsod]

I'm trying to create an invoice. I have a house table and a tenants table. the tenants are grouped by the company they work for. So I did a query for everyone that worked for a specific company. The query pulled all the info (e.g., tenant, which house they are in, the rent for that house, etc.). I wanted to create an invoice (report) based on the query that I made so that I didn't have to filter through all the other people living here. When I tried to create a report based on the query it gave me an error.

[rzw0wr]

I do think that your Tenants and house(address) table should be together.
Unless more that 1 tenant lives at the same address or a tenant live and more than 1 address.

You may want to read up on table normalization.

However, still why are you checking to see if a field is numeric?

Dale

[Kelsod]

I'll read up on that. There are people that live together and people often move around so i just have them connected by the house they are currently in. Thanks! I'm not trying to check and see if a field is numeric. I'm just trying to create a report and that is the error I get. I have no idea what it's asking me. I didn't know how to fix it because I don't understand the error. I don't know what it's referring to.

[rzw0wr]

Compile Error IIf(IsNumeric(tblsStyleName),ApploadString(tblStyl e.StyleName),tblStyles.StyleName'."

This statement is asking if "tblsStyleName" is of an numeric type.
I would start by removing that.
Iif(TestForSomeThing,Truepart,FalsePart)

If you could be a little more specific in what you want it is possible we can get something to work.

As it stands now I have no idea what you are testing tblsStyleName for.

Dale