View Full Version : Excluding records using combination parameters


PaulA
04-08-2002, 07:57 AM
I am having trouble querying data that excludes records where both an identified parameter (specific status codes) occur within a specific date-range parameter within a larger date range. Tried creating column where dates within date range recieve value "1", the rest being "0". I then combined these values with the status codes in a seperate query column and then used parameters to exclude the specific records. Doesn't work!
Any suggestions? Thanks.

Pat Hartman
04-08-2002, 06:21 PM
You should probably post your selection criteria. But, as a guess, I would say that you are using the OR relational operator when you should be using AND. If you have built the criteria using the QBE grid, remember that each cell in a single row is connected with the AND operator and each row is connected with the OR operator.