G
Guest
I created three Sum Queries which resulted in SumofBegBal; SumofATotInc;
SumofTotExp. I tried to create a new query which would give me my ending
balance. In the new query, I put the reference month, and each of the sumof...
in a new column, I put EndBal:[SumOfBegBal]+[SumOfATotInc]-[SumofTotExp]. I
set the group by field to "sum." When I tried to run the query, I received
the error message "Type Mismatch."
Anyone have any ideas what I did wrong? Any help would be greatly
appreciated. k
SumofTotExp. I tried to create a new query which would give me my ending
balance. In the new query, I put the reference month, and each of the sumof...
in a new column, I put EndBal:[SumOfBegBal]+[SumOfATotInc]-[SumofTotExp]. I
set the group by field to "sum." When I tried to run the query, I received
the error message "Type Mismatch."
Anyone have any ideas what I did wrong? Any help would be greatly
appreciated. k