format this 32.2100ffffff to a number w 2 places after decimal

[Mandiab]

I'm working on a query, it pulls a field that is actually a dollar amount, that looks like any of these examples:

1254.2502ffffffffff
12.25fffff
1200.2351fffffffff
10.02
123.05fffffffff

Basically the dollar amount can be anywhere from 1 dollar to a couple of thousand. After the decimal it can be anywhere from two places to a bunch of digits and then normally it's padded with fffffff at the end. I need this to be a number with only two places after the decimal.

Any help is greatly appreciated.

 

[rommelgenlight]

have you done formatting that field to standard format. you can do that by right clicking that field, goto properties and setting its format type.

 

[neileg]

CCur(Val([MyFieldName]))

 

[Mandiab]

It worked Neil you are awesome!!!!!