Type Mismatch

  • Thread starter Thread starter Guest
  • Start date Start date
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access SQL Query: Data Type Mismatch on TimeValue condition 3
Complex Select Query 1
How can I use a text string as a query parameter? 2
Data type mismatch with crosstab 4
summing time 4
i am getting the message "Type Mismatch" 1
Turn Off Access Field Re-name? Calculation fields in query 2
Type Mismatch in Expression 1

Back
Top