iif & And statement in Access

[ianuk1983]

Hello guys,

Still starting out in access I have the following I'm looking to try and do which I built in the expession builder, which doesnt work.

Package: IIf([Voice]>0 And [Blackberry]>0,"Voice & BB","")

I'm simply trying to do a =if(and( statement as I know it in excel. can anyone let me know were i'm going wrong?

Thanks

 

[Marbles]

It looks okay, what results are you getting, and from what field types?

 

[ianuk1983]

If the field Voice & Blackberry are both greater than 0. In the new field the message
#Error

 

[Marbles]

It sounds like you have one of the fields as text instead of number.

 

[Andrew Fergus]

Hi Ian

Is this in a query? If so can you post the full SQL for the query? You can get into the SQL when in the query design screen by clicking on menu option View > SQL View. If this is not in query can you explain where you are using this expression?

Andrew

 

[Marbles]

Andrew

Is that picture from Deliverance?

 

[Andrew Fergus]

Absolutely yes! Finally someone recognised it!!!!!

I sat and watched the movie again the other night. I so thoroughly enjoyed the duelling banjo scene that I decided to change my avatar to Lonny from that scene. IMO that has to be one of the most memorable movie scenes.

Cheers
Andrew

 

[Marbles]

I usually watch Deliverance until few minutes after that scene, then turn it off.

 

[ianuk1983]

Looks to be working now, but I'm working for a way to include 3 fields
example

IIf([Voice]>0 And [Blackberry]>0 And [Data]>0," Voice Data & BB"

but is on looking at the first two, is this even possible?
or a way round this?

 

[Norie]

ian

It should be possible.

But I think you need to answer Marbles original question about the field data types.

Also is it possible for any of the fields to be empty?