P
Peter Kinsman
After many years with Access97, I have moved to 2003, and I am having
problems with decimal fields.
A report driven by a complicated query prints the total of a group, but the
total is always a whole number of pounds. To find what was happening, I
changed the query to a make table query and the value field was decimal with
zero decimal places, even though in its calculation it was divided by
100000. When I changed this to 2 decimal places, everything worked. I then
tried a simple report, driven from a test table with only three fields, one
of which was decimal and the total was wrong. When I changed the decimal
field to a long integer it was correct. I have the decimal fields because
the tables were copied from an AS/400 but is this something to be avoided in
the future?
Many thanks
Peter Kinsman
problems with decimal fields.
A report driven by a complicated query prints the total of a group, but the
total is always a whole number of pounds. To find what was happening, I
changed the query to a make table query and the value field was decimal with
zero decimal places, even though in its calculation it was divided by
100000. When I changed this to 2 decimal places, everything worked. I then
tried a simple report, driven from a test table with only three fields, one
of which was decimal and the total was wrong. When I changed the decimal
field to a long integer it was correct. I have the decimal fields because
the tables were copied from an AS/400 but is this something to be avoided in
the future?
Many thanks
Peter Kinsman