UPDATE: The cause of the error message is because I had several textboxes taking the average of certain fields from tblResults that are actually Text datatypes. BUT, my problem still exists - using one table as source, the report opens (with the averages calculating correctly), using another seemingly identical table, I get an error due to the average textboxes.
I would definitely appreciate any help with this problem as soon as possible. Thanks!
I have a report that should display the results of a query based on two tables (tblClient and tblResult, linked by ClientID).
When trying to open the report I receive the following error: "Data Type Mismatch in Criteria Expression"
The report worked before, so as an experiment I created a new table with a structure identical to tblResult (so I think). The data within is the only difference(it's actually the data that was in the table when I built the report). The report opens fine with this table.
So, my problem is why an error for one table and perfect operation for a splitting image? I've checked the fields, the data types, and the general table attributes - both tblResult's appear to be the same, yet one leads to an error and one leads to a report.
Thanks in advance.