Parsing a field value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field value = "1.99" and I am looking for a formula that will allow
me separate the ".99" for placement in a separate field. Can anyone help me
here?
 
Mike Dixon said:
I have a field value = "1.99" and I am looking for a formula that will allow
me separate the ".99" for placement in a separate field. Can anyone help me
here?
Click to expand...

Fix([FieldName])

Should give you the value to the left of the decimal point. For the value to
the right of the decimal you can use...

[FieldName] - Fix([FieldName])
 
Rick said:
I have a field value = "1.99" and I am looking for a formula that will allow
me separate the ".99" for placement in a separate field. Can anyone help me
here?
Click to expand...

Fix([FieldName])

Should give you the value to the left of the decimal point. For the value to
the right of the decimal you can use...

[FieldName] - Fix([FieldName])
Click to expand...

For me, this returns 0.99 cast as a FLOAT (Double). The OP has implied
the data is text e.g.

SELECT 0.99 AS test_text,
IIF(INSTR(1, test_text, '.') = 0,
'',
MID$(test_text, INSTR(1, test_text, '.'))
) AS test_text_parsed
 
Back
Top