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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by rcolon
-
Query to lookup value in another table, if it exists
Rudy, Thanks for getting back with info so soon! I am deciphering your query, and can you elaborate on it a little. I see the first part as one query which would find the match, and the second part as another query that would use custno=0 if there is no match. Barring any typos in the select...- rcolon
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Query to lookup value in another table, if it exists
Help! We can assign resource descriptions to both generic customer numbers (customer number zero) or a specific customer number (customer number 12345) which reside in a table. For example, resource "ABC" might be described as "paint" for a generic customer (customer zero)...- rcolon
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
