Hi all,
I have 2 tables i wish to check if records exist in both - Unmatched query methinks - however to create a unique identifier for each record I create 2 sub queries that takes the employee ref no and the date for that record, converts the date to text (using a function found on't web)and then concantenates the ref no to the date (now in a numerical text string) - then link the 2 sub queries using a unmatched query - now this is where it all goes wrong.
The 2 subqueries work fine, but the unmatched returns "data type mismatch in criteria expression", I have exported the queries to exel and both the compared fields are text
Here is the sql of the final query
SELECT QryDriverTimesheetExists.Date, QryDriverTimesheetExists.DriverRefNo
FROM QryDriverTimesheetExists LEFT JOIN QryDriverWTDRecord ON QryDriverTimesheetExists.refno = QryDriverWTDRecord.Expr1
WHERE (((QryDriverWTDRecord.Expr1) Is Null));
Has anyone any ideas?
I have 2 tables i wish to check if records exist in both - Unmatched query methinks - however to create a unique identifier for each record I create 2 sub queries that takes the employee ref no and the date for that record, converts the date to text (using a function found on't web)and then concantenates the ref no to the date (now in a numerical text string) - then link the 2 sub queries using a unmatched query - now this is where it all goes wrong.
The 2 subqueries work fine, but the unmatched returns "data type mismatch in criteria expression", I have exported the queries to exel and both the compared fields are text
Here is the sql of the final query
SELECT QryDriverTimesheetExists.Date, QryDriverTimesheetExists.DriverRefNo
FROM QryDriverTimesheetExists LEFT JOIN QryDriverWTDRecord ON QryDriverTimesheetExists.refno = QryDriverWTDRecord.Expr1
WHERE (((QryDriverWTDRecord.Expr1) Is Null));
Has anyone any ideas?
