Manju
asked on
Access - Question on concatenation of field values
Team -
I have a table with 5 columns in access (user creates this table on the fly).
Ex:
Catalog SearchType SearchCriteria SearchTerm BulkQuery
Ex: with Data
Catalog SearchType SearchCriteria SearchTerm BulkQuery
All Test Common Bag Select * from Data where Catalog = 'All' and SearchType = "Test" and Criteria = "Common" and term = "Bag"
so, this table will have 1 or more than 1 rows.
What i need is to concatenate all the "BulkQuery" with union
Ex:
BulkQuery from row1 union bulkquery from row2 etc.
Kindly help,
I have a table with 5 columns in access (user creates this table on the fly).
Ex:
Catalog SearchType SearchCriteria SearchTerm BulkQuery
Ex: with Data
Catalog SearchType SearchCriteria SearchTerm BulkQuery
All Test Common Bag Select * from Data where Catalog = 'All' and SearchType = "Test" and Criteria = "Common" and term = "Bag"
so, this table will have 1 or more than 1 rows.
What i need is to concatenate all the "BulkQuery" with union
Ex:
BulkQuery from row1 union bulkquery from row2 etc.
Kindly help,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
glad to help!
ASKER