Link to home
Start Free TrialLog in
Avatar of Manju
ManjuFlag for India

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,
ASKER CERTIFIED SOLUTION
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Manju

ASKER

Perfect. Thanks
glad to help!