Hello Party people,
I have written a union querry which runs for a bit then gives me this error message
Data type mismatch in criteria expression. (Error 3464)
The explanation for the error is as follows.
The criteria expression in a Find method is attempting to compare a field with a value whose data type does not match the field’s data type.
My understanding of this is that not all fields in both tables are of the same format.
Please correct me if i'm wrong.
I have quite a number of fields, so i was wondering if there is a fast way to compare them, say by a querry or tool.
And if this is not the cause, can someone please advice on the best way forward, lest i waste my whole day going down the wrong path.
Kind regards
I have written a union querry which runs for a bit then gives me this error message
Data type mismatch in criteria expression. (Error 3464)
The explanation for the error is as follows.
The criteria expression in a Find method is attempting to compare a field with a value whose data type does not match the field’s data type.
My understanding of this is that not all fields in both tables are of the same format.
Please correct me if i'm wrong.
I have quite a number of fields, so i was wondering if there is a fast way to compare them, say by a querry or tool.
And if this is not the cause, can someone please advice on the best way forward, lest i waste my whole day going down the wrong path.
Kind regards
Last edited by a moderator:
