Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: ErikNilsson
- Order by date
-
Can this be done in a Query or Filter?
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...- ErikNilsson
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Can this be done in a Query or Filter?
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...- ErikNilsson
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
