Expression under new pc with XP

  • Thread starter Thread starter Eelke
  • Start date Start date
E

Eelke

I use a nested IIF expression in a query like this
Expr1: IIf([pd_nr]<2200300;"Meppel R";IIf([pd_nr]
=2200300 And [pd_nr]<3300000;"Meppel P";IIf([pd_nr]
=3300000 And [pd_nr]<4400000;"Drachten";IIf([pd_nr]
=4400000 And [pd_nr]<5500000;"Emmen";IIf([pd_nr]
=8800000 And [pd_nr]<9900000;"Zwolle";IIf([pd_nr]
=6600000 And [pd_nr]<7700000;"Koudekerk";IIf([pd_nr]
=7700000 And [pd_nr]<8800000;"Utrecht";IIf([pd_nr]
=9900000 And [pd_nr]<10000000;"Woerden";"anders"))))))))
Click to expand...

Working with Access 2000
Under Win NT4 it's running well, now i got a new one with
Win XP and SP3 and fault with syntax in expression and i
get something like this
Expr1: IIf([pd_nr]<2200300;"Meppel R";IIf([pd_nr]
=2200300 And [pd_nr]<3300000;"Meppel P";IIf([pd_nr]
=3300000 And [pd_nr]<4400000;"Drachten";IIf([pd_nr]
=4400000 And [pd_nr]<5500000;"Emmen";IIf([pd_nr]
=8800000 And [pd_nr]<9900000;"Zwolle";IIf([pd_nr]>=66000
Click to expand...
with an button for OK or HELP
Pressing OK quits the query and i can't change it

Who know's ?

Grtz Eelke
 
Hi Eelke,

Is it possible your new computer
expects you to use a comma (US setting)
instead of a semicolon?


Eelke said:
I use a nested IIF expression in a query like this
Expr1: IIf([pd_nr]<2200300;"Meppel R";IIf([pd_nr]
=2200300 And [pd_nr]<3300000;"Meppel P";IIf([pd_nr]
=3300000 And [pd_nr]<4400000;"Drachten";IIf([pd_nr]
=4400000 And [pd_nr]<5500000;"Emmen";IIf([pd_nr]
=8800000 And [pd_nr]<9900000;"Zwolle";IIf([pd_nr]
=6600000 And [pd_nr]<7700000;"Koudekerk";IIf([pd_nr]
=7700000 And [pd_nr]<8800000;"Utrecht";IIf([pd_nr]
=9900000 And [pd_nr]<10000000;"Woerden";"anders"))))))))
Click to expand...

Working with Access 2000
Under Win NT4 it's running well, now i got a new one with
Win XP and SP3 and fault with syntax in expression and i
get something like this
Expr1: IIf([pd_nr]<2200300;"Meppel R";IIf([pd_nr]
=2200300 And [pd_nr]<3300000;"Meppel P";IIf([pd_nr]
=3300000 And [pd_nr]<4400000;"Drachten";IIf([pd_nr]
=4400000 And [pd_nr]<5500000;"Emmen";IIf([pd_nr]
=8800000 And [pd_nr]<9900000;"Zwolle";IIf([pd_nr]>=66000
Click to expand...
with an button for OK or HELP
Pressing OK quits the query and i can't change it

Who know's ?

Grtz Eelke
Click to expand...
 
Back
Top