Why it gives me integer

M

Minnow

I have two fields A and B, both double. In a query, I want A\B and give me a
percentage, but it gives me integers which are 0s, 1s and 2s.

Any help is highly appreciated.
 
D

Douglas J. Steele

A\B is defined as integer division. The "proper" division character is /,
not \.
 
C

Chaim

The '\' operator is an INTEGER divide operator. The '/' operator is a FLOAT
divide operator.
 
Top