Access 2007 Query

[twalsh]

Im trying to do an update query in Access 2007. Real simple dividing one
number by another to get a ratio. When i run the query it only returns 0s and
the occasional 1. I don't see what could be causing it, the same query worked
just fine in access 2003. is there something im missing?

 

[Albert D. Kallal]

'
There's been no change in this regards from access 2003 to 2007, so my guess
is perhaps the column that you've defined is an integer or long integer type
field in which only whole numbers are allowed.

I would open up the table in design mode and check the data type that you
have.You'll have to use a single, double or perhaps a currency data type in
which fractional values are allowed.

 

[twalsh]

Hmmmmm, the little things we overlook :-\ Thanks!!!