Well I tried this and it gives me an error. "At most one record could be returned by this sub Query"
(SELECT [AccountNum] FROM [OrdersText]WHERE NOT (AccountNum = 'pending') AND NOT isNull(Rep))
That is my statement Im not that great with writing these so if anyone sees something...
I have multiple tables linked into a Query. This is used to build a Report with Account #'s and other personal information.
What Im trying to accomplish is when the Account# = Pending and the Rep name is null I want to exclude these from the report. But when the Account# is a real account...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.