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.
Any suggestions? Thanks.