Query Prompt - Multiple Criteria 关注
I'm curious to know if it's possible to have multiple criteria at query prompt time when connected to a database. I currently have the below SQL working in a Bartender 8.01 Enterprise format.
[code]SELECT DISTINCT `WC`, `JOB #`, `ITEM` FROM `tblSchedule` WHERE `JOB #` = '?JOBNUM' [/code]
This query works as designed, but since we might have certain 'jobs' go through multiple 'workcells' (WC), then the format will print multiple records.
I would like to see something along the lines of...
[code]SELECT DISTINCT `WC`, `JOB #`, `ITEM` FROM `tblSchedule` WHERE `JOB #` = '?JOBNUM' AND 'WC' = '?WC'[/code]
This would allow me to get the correct number of records. When attempting this SQL statement, I do not get a 2nd query prompt and no records return as a result.
Any info or insight appreciated.