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!
Search results for query: *
- Users: mpspillers
- Content: Threads
- Order by date
-
Subquerying inside a LIKE statement?
Hi! I'm making the big switch from MS Access to SQL, and I'm having a hard time translating one of my old Access queries to SQL syntax. I have 2 tables, [tblPerson] and [tblTitles]. I want to see every record in [tblPerson] where the [tblPerson].[role] field CONTAINS (is LIKE) any of the...- mpspillers
- Thread
- Replies: 14
- Forum: ANSI_SQL
-
concatenate fields for a combo box?
Hi, folks - I'm building a database that tracks visitors to a clinic. Three of the fields in the [clients] table are: [client1stname] [clientlastname] [clientphone] In one of my forms I want the user to be able to pull down a combo box that concatenates these three items to use as the...- mpspillers
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
