Probabaly let me explain again the data situation. The data I am download from my company system & I am try to analyse with query. One of the field, the so call [Product], has the combinations of either one or two or even three product. ( I understand that the table is not been normalised but I...
I think you may misunderstand my product name. The DB I had does not have fix alphbet for product1 and product2. It may vary from 5 to 15 characters.
Also today i found out that the combineroduct field may contains product1+product2+product3...!!It make me further confuse..
sorry, i am new in programming & not sure of using Split function.
Also I do not know how to use the coding. I had try in the query expression but it does not work.
Thanks
Hi,
I have a field which has already contain the product name as :
EnchSG100ml,
EnchSG100ml+RomaSH50ml,
EnchSH250ml+RomaHB100ml,
RomaSG700ml+EnchSH120ml,
RomaHB250ml,
(Where Ench/Roma are product brand, SG/SH/HB are product type & ml is the product volume & "+" means the it banded together as...
I am constructing a DB for my company who manufacture consumer toiletary products e.g shower gel, shower cream, shampoo ..etc. In the DB ,one of the table on the product formulation which build by the BOM (Bill of Material) & it must be kept highly confidential. This table, so called BOM...
I am joning these 2 tables with [Product Code] to [Product No] in a query. Question is : how can I retrieve those [Product Code] which is not equeal to [Product No]?
I believe I need to use a SQL to relate it but how is it? Is it Not equal To or <>, I had tried both but fails....
Please teach...
Hi,
I am new in database & have some basic questions that need your help.
I wanted to set up a very basic product & product code so that it will be easy to be access & enter. I am selling numbers of brand (Enc,Rom,Vig,Juc) with different categories (Shampoo, Shower Gel, HB Lotion...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.