Trying to get my Query to omit several categories or accounts and cant seem to figure out how to use "NOT" with multiple Criteria In the image below I am trying to omit "other" "Loans" "Fines" "Chapter Dues" I have tried several different ways using the Criteria but not of them work Thanks
TransAccountName NOT IN ("other", "Loans", "Fines", "Chapter Dues")
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Forum Rules