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?
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?