Math problem

[Ana]

Hi,
I'm having a problem with the following equation and I don't understand it.

In Details from a query I have Claims (text1), Sales (text2) and =Claims /
Sales (text3).

The latter real numbers are: 32991 / 91362 which return 0, 36. However, the
Form returns 120,84. Can someone, pls, tell me what am I missing?

TIA

Ana



Access 2003, XPpro, SQL2k

 

[Rick B]

text?

Why are you storing numbers in a text field? You want to perform math on a
text field?

 

[Amy Blankenship]

In the same vein, look at the CInt() function.

HTH;

Amy