Solved Using a single precision field as condition

[XPS35]

I use the Dutch versions of Access and Windows. That means that the decimal separator is set to a comma by default.
In a table I have a numeric field (single precision). Entering and displaying values works fine for this field.
However, if I use the field as a condition in a function, I get an error. For example, the following function returns an error:

MsgBox DSum("ItemValue", "MyTable", "ItemValue <= " & Me.ItemValue)

The error is:

[syntax error (comma) in query expression ....]

How do I modify the code to get a good result?

 

[ebs17]

The criteria in DSum expects an SQL filter, in English with US formats. Therefore, the comma must be treated.

MsgBox DSum("ItemValue", "MyTable", "ItemValue <= " & Str(Me.ItemValue))

 

[XPS35]

Thanks, that works.