compare Currency to Number ???

[smig]

I'm trying to compare a Currency formatted field to a Number formatted one and getting wrong results.

Any idea, other then formatting the Number as Currency too ?
Tried to use Val() but the Currency returned 0

 

[pr2-eugin]

Can you give some examples please?

 

[smig]

I get 280 > 280 ILS as true

Maybe because the herew ILS currency symbol is on the left of the number ?

 

[pr2-eugin]

No you will not. I am not sure if currency symbol follows the number or number follows the currency symbol. I would have thought the symbol should come first.. Something like this then?

? CCur(280) > CCur(CDbl("280 £"))
False

 

[smig]

If I format the number as currency, or vise versa, it will work.
Problem is when one Is a number and the other formated as currency.

 

[Minty]

Is the number an integer or float ?

 

[smig]

Is the number an integer or float ?

Im realy not sure
The source is a query. Both are coming from a currency formated fields in the table.
Because the query is used for a list box one of the fields formated as currency. The other is hidden in the list box so its not formated.

 

[EdFred]

I've had issues where a number/currency displays as 284.32 actually ends up being 284.320025841 or some other trailing numbers even with limiting decimal places to 2.

Is that possible?