IIf statement field asking for Paramaters?

[jyadayada]

I've had this before but every version i submit when i switch to datasheet view asks for Paramaters, i'm creating a field ina query called Group_Space_Available_CM and the expression reads:


Group_Space_Available_CM: IIF([Space_Type]="Legacy",[Space_Available_CM]/6,IIF[Space_Type]="Dual",[Space_Available_CM]/10))


I've got other IIF staements in the saame query that are written the same way and they don't ask for paramaters?

 

[Minty]

Double check the typing, that's frequently caused by a mis-spelt field name.

 

[Ranman256]

you missed the left paren on the 2nd IIF

,IIF([Space_Type]="Dual",[Space_Available_CM]/10))

 

[jyadayada]

that was a typo in here, it's in in the access query


IIf([Space_Type]="Legacy",[Space_Available_CM]/6,IIf([Space_Type]="Dual",{Space_Available_CM]/10))


I've taken it out and rewritten it and it still snags

 

[Gasman]

IIf([Space_Type]="Legacy",[Space_Available_CM]/6,IIf([Space_Type]="Dual",{Space_Available_CM]/10))

 

[jyadayada]

IIF([Space_Type]="Legacy",[Space_Available_CM]/6,IIF([Space_Type]="Dual",[Space_Available_CM]/10))


it's written correctly in the access query, I keep mistyping in here as i'm on two machines, the field names are correct, everythings spelt right, bracketed right,

 

[Minty]

What about in any underlying queries then?
If you haven't set any parameters it will only ask when it can't identify where it's supposed to find what it's asking you for?

Screenshot the parameter input box and show us what it is asking for?

 

[jyadayada]

Thank you!


There's another expression in the query referring to this field, which I had now renamed after IIFing it, what a doof!

 

[Gasman]

IIF([Space_Type]="Legacy",[Space_Available_CM]/6,IIF([Space_Type]="Dual",[Space_Available_CM]/10))


it's written correctly in the access query, I keep mistyping in here as i'm on two machines, the field names are correct, everythings spelt right, bracketed right,

Try Copy and Paste then?