Calculated field dropping cents

[Stacey]

Hello.
I have done this umpteen million times, but for some reason, this one isn't working. I have a query that is summing amounts by [Carrier]. There can be as many as 50 carriers per [Group]. So I am displaying the list of carriers and amounts on a continuous form, frmVendorList, per group, with a calculated field on the form footer that is summing the [SumOfAMOUNT] field. It is set to currency format. It is not working properly, though. If it is summing $10.50 and $5.25, it only gives a sum of $15.00. It is displaying the cents fields, but only as zeros.

Any ideas?

I don't know if it is important or not, but the display form is accessed from a button on another form, frmPlanGroups, and the display is filtered by the Group showing in a field on frmPlanGroups.

Thanks.

 

[CEH]

Change the field to single or double???? Lots of post here on problems rounding.

 

[Stacey]

I searched before I posted, I always do. All I could find were questions on how to round up or down. I don't want it to round, and it is. What do you mean by change to single or double?

 

[RuralGuy]

Curtis is suggesting you check your field types. Integers will only store whole numbers. You need a field type of either Currency, Single or Double to store the decimal values. I recommend Currency.

 

[Stacey]

I found a workaround. Thanks.

 

[alejo8955]

what was your work around? i am having the same issue, thanks

 

[namliam]

wow 7 year old thread, good luck Alejo

 

[alejo8955]

jajaja... i didnt notice how old it was.... but i just found my answer... thanks!