Data type mismatch in criteria expression

[Moxioron]

Hello all.

I have a query that I am trying to reflect the summary of an expression from another query. Here is my SQL:

SELECT [Qry_VISA Re-Pricing Detail - Impact Analysis].Disposition8, Count([Qry_VISA Re-Pricing Detail - Impact Analysis].[Card Number]) AS [CountOfCard Number], Sum([Qry_VISA Re-Pricing Detail - Impact Analysis].[Credit Line]) AS [SumOfCredit Line], Sum([Qry_VISA Re-Pricing Detail - Impact Analysis].[Last Statement Balance]) AS [SumOfLast Statement Balance], Sum([Qry_VISA Re-Pricing Detail - Impact Analysis].[Last Statement Cash Balance]) AS [SumOfLast Statement Cash Balance], Sum([Qry_VISA Re-Pricing Detail - Impact Analysis].[Merch Balance]) AS [SumOfMerch Balance], Sum([Qry_VISA Re-Pricing Detail - Impact Analysis].[Avail$]) AS [SumOfAvail$]
FROM [Qry_VISA Re-Pricing Detail - Impact Analysis]
GROUP BY [Qry_VISA Re-Pricing Detail - Impact Analysis].Disposition8;

Disposition8 is an expression from Qry_VISA Re-Pricing Detail - Impact Analysis.

I want to provide a summary of each disposition I identified with my expression in the previous query. However, the SQL above gives me the Data type mismatch message.

Is it because I am using 'Group By' in this query on an expression?

Thanks.

 

[Joe4]

Do all the fields you are summing have a numeric data type?
I would recommend starting from scratch, just adding the first field to the query and Grouping by it. Then, one-by-one, add your aggregate functions and check them until you find where the error is occurring. Then you will be able to identify the expression causing issues.