Calculating miles per gallon Access 2007

[Guest]

I have two field as Long Integer. Gas purchased and miles driven.

It calculates ok but rounds 10.5 gallons to 11. How can I set it up so it
will calculate tenths of gallons and tenths of miles?

Thanks

 

[Ken Snell \(MVP\)]

Change the Field Size of the Gas purchased field to Currency or to Single or
to Double. You're trying to store a fractional number in an integer field;
won't work.

 

[Guest]

I should have said gallons purchased which would rule out the currency.

Thanks,

 

[Guest]

I changed the table fields to single and decimal to 1.
It still don't change until I change from 10 to 10.6 gallons which it will
indicate 27 from 30 mpg. Miles won't change until I go from 300.0 to 310.0.
which will indicate from 30 to 31mpg.
This is the formula I'm using in the query.
Expr1: +[Miles_Driven]\[Gallons_Purchased]

Any suggestions would be appreciated

 

[Ken Snell \(MVP\)]

Currency is a data type that keeps accurate numbers to four decimal places.
It's not just for currency data -- it's used often for numbers that can have
up to four decimal places when you want exact numbers, not "floating point"
numbers. Makes your calculations more accurate too.
--

Ken Snell
<MS ACCESS MVP>

 

[Ken Snell \(MVP\)]

You're using integer division when you use the \ operator. Try this:

Expr1: [Miles_Driven]/[Gallons_Purchased]

--

Ken Snell
<MS ACCESS MVP>

I changed the table fields to single and decimal to 1.
It still don't change until I change from 10 to 10.6 gallons which it
will
indicate 27 from 30 mpg. Miles won't change until I go from 300.0 to
310.0.
which will indicate from 30 to 31mpg.
This is the formula I'm using in the query.
Expr1: +[Miles_Driven]\[Gallons_Purchased]

Any suggestions would be appreciated

Change the Field Size of the Gas purchased field to Currency or to Single
or
to Double. You're trying to store a fractional number in an integer
field;
won't work.

 

[Guest]

Thank you very much. Its working fine with double.

You're using integer division when you use the \ operator. Try this:

Expr1: [Miles_Driven]/[Gallons_Purchased]

--

Ken Snell
<MS ACCESS MVP>

I changed the table fields to single and decimal to 1.
It still don't change until I change from 10 to 10.6 gallons which it
will
indicate 27 from 30 mpg. Miles won't change until I go from 300.0 to
310.0.
which will indicate from 30 to 31mpg.
This is the formula I'm using in the query.
Expr1: +[Miles_Driven]\[Gallons_Purchased]

Any suggestions would be appreciated

Change the Field Size of the Gas purchased field to Currency or to Single
or
to Double. You're trying to store a fractional number in an integer
field;
won't work.

--

Ken Snell
<MS ACCESS MVP>


I have two field as Long Integer. Gas purchased and miles driven.

It calculates ok but rounds 10.5 gallons to 11. How can I set it up so
it
will calculate tenths of gallons and tenths of miles?

Thanks