Query totals loses decimal amounts

[ClaraBarton]

I feel like I'm seriously overlooking something simple here. In the attached sample 3qryTransTotals has a field CAmount that is carried to 5qryRegister. In the 5qryRegister it loses its decimal amounts. This leaves the calculated field Remaining with various cents. All fields are Currency types and formatted as standard with 2 decimals.

 

[Gasman]

I think it is corrupt?
I changed decimal places to 4 and it removed them altogether. 6 was the same. Put back to 2 and the display did not change, just integers.

No idea though to be honest.
I created a new db and imported everything and it went haywire?

 

[Gasman]

is this correct for tblCheckCat?

BTW, you do not need to give a field an alias of the same name as the field.

 

[Gasman]

I honestly have no clue what you have done here.

 

[xavier.batlle]

I've removed all the formats in the currecy columns and it seems to work properly. To be honest I don't understand why!

 

[Minty]

Decimal field with a scale of 0 will have no decimal value after the integer...

 

[Gasman]

Decimal field with a scale of 0 will have no decimal value after the integer...

I cannot get hers to change? It keeps going back to 0 for scale. I have tried reducing precision as well?

Aha, changed it to currency and voila!

 

[ClaraBarton]

Ok, saying you didn't know made me feel better. I went back and CAREFULLY checked my tables for Currency and formats, made a minor change and things seem to be working. The Alias is because I want the field name but a Totals query changes it to "Sum of FieldName." Thank you for taking the time to look at it.

 

[Gasman]

The Alias is because I want the field name but a Totals query changes it to "Sum of FieldName."

Yes, I saw that one, but you also had Amount for Amount somewhere.
I removed it in my copy, so cannot find it now.

TBH, I could not see how it was happening. You had zero in the 3 query and then all of a sudden a positive remainder value from that in the 5 query.

Very weird.