Question

Locked

Asking twice on MSAccess 2003

By rayasta ·
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!

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Web Development Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums