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

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>


"Fly Boy 5" <(E-Mail Removed)> wrote in message
news:B0119C6A-7CDA-4124-9E25-(E-Mail Removed)...
>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

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

Thanks,

"Ken Snell (MVP)" wrote:

> 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>
>
>
> "Fly Boy 5" <(E-Mail Removed)> wrote in message
> news:B0119C6A-7CDA-4124-9E25-(E-Mail Removed)...
> >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
>
>
>

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)" wrote:

> 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>
>
>
> "Fly Boy 5" <(E-Mail Removed)> wrote in message
> news:B0119C6A-7CDA-4124-9E25-(E-Mail Removed)...
> >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
>
>
>

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>





"Fly Boy 5" <(E-Mail Removed)> wrote in message
news:AAF80C64-8A27-4421-BEB9-(E-Mail Removed)...
>I should have said gallons purchased which would rule out the currency.
>
> Thanks,
>
> "Ken Snell (MVP)" wrote:
>
>> 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>
>>
>>
>> "Fly Boy 5" <(E-Mail Removed)> wrote in message
>> news:B0119C6A-7CDA-4124-9E25-(E-Mail Removed)...
>> >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
>>
>>
>>

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

Expr1: [Miles_Driven]/[Gallons_Purchased]

--

Ken Snell
<MS ACCESS MVP>



"Fly Boy 5" <(E-Mail Removed)> wrote in message
news:58A6702E-5E01-4694-91F0-(E-Mail Removed)...
>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)" wrote:
>
>> 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>
>>
>>
>> "Fly Boy 5" <(E-Mail Removed)> wrote in message
>> news:B0119C6A-7CDA-4124-9E25-(E-Mail Removed)...
>> >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
>>
>>
>>

Thank you very much. Its working fine with double.


"Ken Snell (MVP)" wrote:

> You're using integer division when you use the \ operator. Try this:
>
> Expr1: [Miles_Driven]/[Gallons_Purchased]
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
>
>
> "Fly Boy 5" <(E-Mail Removed)> wrote in message
> news:58A6702E-5E01-4694-91F0-(E-Mail Removed)...
> >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)" wrote:
> >
> >> 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>
> >>
> >>
> >> "Fly Boy 5" <(E-Mail Removed)> wrote in message
> >> news:B0119C6A-7CDA-4124-9E25-(E-Mail Removed)...
> >> >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
> >>
> >>
> >>
>
>
>