Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jiayue
  • Content: Threads
  • Order by date
  1. jiayue

    Split a field

    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...
  2. jiayue

    Table Security

    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...
  3. jiayue

    Not Equal to

    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...
  4. jiayue

    Simplify Data Enter

    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...

Part and Inventory Search

Back
Top