Hi all,
I am in dire need of help building an expression in query. The query looks for potential duplicate customers by query tblCustomers against two fields [MDL] and [MVL].
Basically, what I want to achieve is -
- If txtMDL = [MDL] OR txtMVL = [MVL] select the record in the query
- If txtMDL or txtMVL is empty, do not select the record unless the above is true.
I had something like ([MDL] Like "*" [Forms]![frmEnquiry]![txtMDL]) Or ([MVL] Like "*" [Forms]![frmEnquiry]![txtMVL]).
If there was a match, it selected the record however I am not sure how to get rid of unwanted records (where the txtcontrols are empty).
If I set the expression to [MDL] = [Forms]! etc then no records are returned?
Could someone please help - I am at my wits end with this one.
Thank you
Robert
I am in dire need of help building an expression in query. The query looks for potential duplicate customers by query tblCustomers against two fields [MDL] and [MVL].
Basically, what I want to achieve is -
- If txtMDL = [MDL] OR txtMVL = [MVL] select the record in the query
- If txtMDL or txtMVL is empty, do not select the record unless the above is true.
I had something like ([MDL] Like "*" [Forms]![frmEnquiry]![txtMDL]) Or ([MVL] Like "*" [Forms]![frmEnquiry]![txtMVL]).
If there was a match, it selected the record however I am not sure how to get rid of unwanted records (where the txtcontrols are empty).
If I set the expression to [MDL] = [Forms]! etc then no records are returned?
Could someone please help - I am at my wits end with this one.
Thank you
Robert
