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!
Recent content by jonohara999
-
Strip data from Concatenated string
Fantastic thanks very much for all your help. Jon- jonohara999
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Strip data from Concatenated string
Thanks that's great. The sql i'm currently using is Concatenate("SELECT intcatalogid FROM tblsofabedsCONCAT WHERE categoryidsb =" & [categoryidsb]) AS relatedproducts FROM tblSofaBedsCONCAT; Where intcatalogid is the 'productid' Jon- jonohara999
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Strip data from Concatenated string
HI There I've used the concatenate code, from the FAQ in this forum, to create a string of related products on my shopping cart. This works well, but i'd like to strip out one of the values in the string which is a duplicate. So i currently return data like this... productid...- jonohara999
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
