Query totals loses decimal amounts (2 Viewers)

[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.