Access Data Type Mismatch Error

Question

Hi I have an Access Database that has worked well in the past and it now has an error I can't figure out how to fix. The error reads "Data Type Mismatch in Criteria Expression"

Please help me figure this out.

Answer 1

There are records in that displayed group of records with nulls in different columns, such as Qty and Total. You are trying to Sum() on Qty and Total. If you exclude those records with Null in those fields (and any other fields with Null in one or more records), what happens?

Do you know the technical importance of Nullin a relational database application? It is not the same as saying "blank".

BTW: It looks like your data might be coming from an import file downloaded from a website selling items? If so, that might account for the non-normalized table design. On the other hand, specifying that in the original question would be helpful as a background to what you are trying to accomplish.

Answer 2

PK = Primary Key, the index every table should have that indicates uniqueness of each row.

Answer 3

Yes, I am importing a file I am getting from a website that I sell on.

What I am trying to accomplish is to group and consolidate what parts I sold. Ex. If I sold multiple black tiles to different people, Qty 10 and Qty: 7, it would show that info like in row 3 with the total Qty and Price.

Answer 4

"There are records in that displayed group of records with nulls in different columns, such as Qty and Total. You are trying to Sum() on Qty and Total. If you exclude those records with Null in those fields (and any other fields with Null in one or more records), what happens?"

"Do you know the technical importance of Nullin a relational database application? It is not the same as saying "blank"."

Answer 5

I'm not sure how to even test that.

I deleted the rows down to a couple, and it didn't change anything.