B
BobG
1. Using Access 2000 and 2002
2. MyField (RunningDistance, in miles)
3. Using long integers as data type
Desired result: I want to reflect my actual daily mileage
up to a tenth of a mile (in tables, queries, forms, and
reports).
Example: 7.7 miles
Unexpected result: The mileage automatically rounds up or
down to the nearest whole number.
Example: 7.7 miles rounds to 8. The format looks like x.00
but the entry automatically reflects 8.00.
Ideas? Thank you.
2. MyField (RunningDistance, in miles)
3. Using long integers as data type
Desired result: I want to reflect my actual daily mileage
up to a tenth of a mile (in tables, queries, forms, and
reports).
Example: 7.7 miles
Unexpected result: The mileage automatically rounds up or
down to the nearest whole number.
Example: 7.7 miles rounds to 8. The format looks like x.00
but the entry automatically reflects 8.00.
Ideas? Thank you.