Missing operator?

[Flippertje]

Since a few days i'm using access 2003 dutch version under windows xp dutch version (from acces97 ducth version also but under windows98 dutch version). I've encountered a problem in QBE.

I have a query (in QBE) which has been build on a table. In this query are fields from the table : Product, ProductDate, Productype.

On the field Producttype i've entered a criterium wich is linked to a form:

iif(forms![Frm_Lists].[Product]="Flipper","Divingproducts","NonDicongProducts")

In access97 this worked but in access2003 i get the error that the operator is missing. I've tried all kinds of operatrs (, . ; nothing works.

Also in straight forward really simple query's in QBE when entering a criterium using eg. Iif (immediate if) Access gives an error that the operator is missing....

(please don't ask why i've build this, the question i'm asking is about the operator)

Please can anyone help me out. I have lots of query's build in QBE and none of the query's using an operator in the criteria fields work anymore... please help ....

Thanks!

 

[PHV]

Replace this:
iif(forms![Frm_Lists].[Product]
By this:
IIf([Forms]![Frm_Lists]![Product]

You may also have to replace the commas (,) by semicolons (

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Flippertje]

Thanks for your suggestions.

The replacement between commas and semicolons is what i'm trying to say in my post. This is not working. I've tried replacing them by a , . ; : and still the error occurs.

Thanks!

 

[Flippertje]

I found out the problem occurs with ducth windows xp and access 2003 (perhaps earlier versions until 2000).

The dutch settings in windows xp are like 100.000,00
E.g. the VS settings are like 100,000.00

The combination in dutch products (XP/Access) result in an error and the inability to use statements like Immediate If in the QBE.

For now i have set the countrysettings to English(United States) to workaround the problem.

I hope one of you has a better way to correct it?

Thanks!!

 

[Flippertje]

Problem solved

It seems that a Dutch version of windowsXP sets the listseperator to a dot. I've had to set it to semiicon because Access2003 does not accept any other listseperator.

Change it in Countrysettings, Adjust you're country and look under numbers.

It's a bug in Access!