Access 2012, XP
In qryA I have a field of numbers. QryB is based on qryA, and pulls in ONLY the field with numbers. When I try to sum the field of numbers in qryB, I get the following error:
Data type mismatch in criteria expression.
I am trying to sum the column by first selecting the Totals function, and then selecting "sum" in the "Total" line (Design view).
I don't see anything except numbers in the field. The property for the field indicates "Standard." So I'm stumped.
Ideas?
Thx, William
In qryA I have a field of numbers. QryB is based on qryA, and pulls in ONLY the field with numbers. When I try to sum the field of numbers in qryB, I get the following error:
Data type mismatch in criteria expression.
I am trying to sum the column by first selecting the Totals function, and then selecting "sum" in the "Total" line (Design view).
I don't see anything except numbers in the field. The property for the field indicates "Standard." So I'm stumped.
Ideas?
Thx, William