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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Query Creation Help
The general pseudocode I would use to do this would be something like: cities=[array of cities] keywords[array of keywords] for each city in cities: for each keyword in keywords: sql_query=("SELECT TOP 1 Table.Name, Table.City, Table.Data FROM Table WHERE (Table.Data Like (keyword)) AND...- yamanory
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
Query Creation Help
Hi, I'm trying to create a query in MS Access/SQL and can't seem to figure out how to do it exactly. Just say I have 3 columns: Name - City - Data I have a list of cities, and a list of data 'keywords' (ie. a word that is found in the data). I want a name for each unique keyword in each...- yamanory
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
