I am attempting to calculate an average mortality rate by multiplying 3 variables from 2 different tables in access. It works fine if I multiply each record separately, or I use the access "totals" of summing. When I attempt to use the average "total", I run into problems where I lose the decimal places of my number. Do you know how I can get around this?
I am running a make table query, and if I go to display mode I see the correct values. It only becomes a problem when I run the query.
To answer please click on Q or A sign on the left of the subject.
Written and designed by
Send us your comments
Copyright © 1998-2007 by MAUG