Hi to all!
I’ve an issue that I really have no idea why is happening…
When I FIRST run the query shown below, it’s asking me twice the field “[PLC]”. When this happens, I only need to insert the value I’m looking for on the second pop-up window.
SELECT *
FROM Table1 S
WHERE (((S.Field1) Like [PLC]) AND ((S.Field2) Like ‘I:*’ OR (S.Field2) Like ‘O:*’))
ORDER BY S.Field1, S.Field2;
However, when I run it again, it only ask me the PLC field once.
I have more queries where I use the ((S.Field1) Like [PLC]) but this is the only one with this problem.
I know it sounds weird but it’s happening… I would appreciate any help or advice.
Best Regards!
