hi jdraw, I don't want to make it complicated. I have limited sql knowledge and I have written a few queries already to give me my end output. If I normalize all the tables, I will have to redo all the queries I already wrote.
I was thinking there will be a simple way of splitting the string...
Hi, I have two tables CategoryMaster and ProductMaster.
category_id Category Name
10 Test1
11 Test2
15 Test3
28 Test4
products_id model categories
301 modA 10|11
302 modB 11|15
303 modC 10|28|15
I want to display the category values along with the products. Can someone help me with a query or...
Hi, I am new to access programming and have some knowledge of sql. I have got a lot of help from the forum already and able to write some basic functions and subs :).