Hi all,
I was wondering if you could help me with my error.
I have searched for a response, but I can't figure anything out for my specific problem.
I have set up a query, called 'Pending_calibration_EST'.
This query is to show me records that are pending action by my team, for a particular supplier.
In the status field my criteria is "Returned (Pending)". This works fine, and only shows records that are pending.
However, when I try to specify the supplier in the criteria field i.e. "Supplier Alpha" the error message below appears when I run the query.
Data type mismatch error in criteria expression.
I just can't figure this out, and it is driving me potty. The 'supplier' field is sourced from a lookup from another table, is this what is causing the problem?
Many thanks guys, Gerdagan
I was wondering if you could help me with my error.
I have searched for a response, but I can't figure anything out for my specific problem.
I have set up a query, called 'Pending_calibration_EST'.
This query is to show me records that are pending action by my team, for a particular supplier.
In the status field my criteria is "Returned (Pending)". This works fine, and only shows records that are pending.
However, when I try to specify the supplier in the criteria field i.e. "Supplier Alpha" the error message below appears when I run the query.
Data type mismatch error in criteria expression.
I just can't figure this out, and it is driving me potty. The 'supplier' field is sourced from a lookup from another table, is this what is causing the problem?
Many thanks guys, Gerdagan
