Hi,
I need you help...I am doing my Final Year Project now...
My database has a table call "Data", inside the table there are 2 fields-"Supplier" and "Product". The string value in product column is comma separated (Shown Below).
Product
1 HOSE, FITTINGS
2 GENERAL HARDWARE
3
4 IC CHIPS, CONNECTOR
5 GENERAL HARDWARE
6
....
The rows of this column is unlimited and product is updating. I need to get all the products (values) in the column and filter duplicated values (like 2 and 5) and skip blank row (like 3)...But the question is inside a row, there may be more than one product separated by comma. Can help me how the get the comma separated value and list down in a table (Query?Module?Macro?)?
Expected result:
Product
1 HOSE
2 GENERAL HARDWARE
3 FITTINGS
4 IC CHIPS
5 CONNECTOR
....
after that, the values should be added to a combo box allow user to choose.
And I think there should be a loop function to scan the whole column so to get the products...
Will be appreciate for your reply....
I need you help...I am doing my Final Year Project now...
My database has a table call "Data", inside the table there are 2 fields-"Supplier" and "Product". The string value in product column is comma separated (Shown Below).
Product
1 HOSE, FITTINGS
2 GENERAL HARDWARE
3
4 IC CHIPS, CONNECTOR
5 GENERAL HARDWARE
6
....
The rows of this column is unlimited and product is updating. I need to get all the products (values) in the column and filter duplicated values (like 2 and 5) and skip blank row (like 3)...But the question is inside a row, there may be more than one product separated by comma. Can help me how the get the comma separated value and list down in a table (Query?Module?Macro?)?
Expected result:
Product
1 HOSE
2 GENERAL HARDWARE
3 FITTINGS
4 IC CHIPS
5 CONNECTOR
....
after that, the values should be added to a combo box allow user to choose.
And I think there should be a loop function to scan the whole column so to get the products...
Will be appreciate for your reply....