E
excelCPA
I am attempting to write a query joining two linked tables in a query
by payroll number (all numeric). When write the query and join by
payroll number I get the "Data Type Mismatch in Expression" error.
Both tables have the Data Type as "Number", but the only difference I
can tell is one has "Field Size" as "Decimal" and the other has "Field
Size" as "Double".
I have even tried to join on the VAL() of each payroll number field
with no luck. Any ideas?
by payroll number (all numeric). When write the query and join by
payroll number I get the "Data Type Mismatch in Expression" error.
Both tables have the Data Type as "Number", but the only difference I
can tell is one has "Field Size" as "Decimal" and the other has "Field
Size" as "Double".
I have even tried to join on the VAL() of each payroll number field
with no luck. Any ideas?