intersection of 2 tables

[indigo993]

I have 2 tables with the same fields- check number, amount and date. The one
table I have created using data from the bank. The 2nd table is created from
using data from our gl system. Check dates is the only thing that will
differ. I want to only see those records that are in both my bank file and gl
system (ie, checks posted in gl and cashed at bank). When i run my query, I
get an error message "type mismatch in expression". What am I doing wrong?
If I take out the date fields, I have no problem running the query but the
dates are important.

 

[indigo993]

That is what I have done - only have joined the check numbers, and I get the
type mismatch error message. I did remove the date fields from both my
tables and reran the query and it worked but the dates are important for my
output. So it has something to do with my dates.

 

[John W. Vinson]

I have 2 tables with the same fields- check number, amount and date. The one
table I have created using data from the bank. The 2nd table is created from
using data from our gl system. Check dates is the only thing that will
differ. I want to only see those records that are in both my bank file and gl
system (ie, checks posted in gl and cashed at bank). When i run my query, I
get an error message "type mismatch in expression". What am I doing wrong?
If I take out the date fields, I have no problem running the query but the
dates are important.

There's an error in your query - which we cannot see. "Type mismatch" suggests
that you're either joining two fields of different datatype (i.e. is the check
number a Text field in one table and a Number field in the other) or using
some other expression which has clashing datatypes.

Please post the SQL view of the query.