Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2005
    Posts
    2

    Question Unanswered: Multiple Values in one field

    Example: tblEngine

    Eng_Num' Eng_Mod' Eng_Fuel'
    1 ' G59 ' Propane'
    2 ' G59 ' Natural Gas'
    3 ' G59 ' Liquid Propane'

    Is there a way in Microsoft Access to have multiple values in one field to reduce extreme amount of duplication such as:

    Eng_Num' Eng_Mod' Eng_Fuel'
    1 ' G59 ' "Propane" OR "Natural Gas" OR "Liquid Propane" '

    This is just an example of what I need, I am having to work with 1000s of items with 5 to 6 requirements in one field and rather than having to input 6000 things just for 1000 things, any help would be greatly appreciated

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    If G59 & Propane makes that particular engine Unique, then any time you need to refer to that engine, you put it's ID ("1") in the Eng_Num field in another table:

    tblEquipment
    Code:
    EquipID     ModelNum     ENG_NUM
    1               6427            2
    2               7333            1
    3               4589            2
    The eng_num in tblEngine is the primarykey, and links to ENG_NUM in tblEquipment.
    Inspiration Through Fermentation

  3. #3
    Join Date
    Mar 2005
    Posts
    2
    hmmm its more complicated than what I have stated:

    I have 34 columns to one product, in each column can be anywhere from 1-100 different values

    Continued Example:

    Eng_Num'..Eng_Mod'.......Eng_Fuel'................ ..Voltage'
    1 '............G59 '............Propane'....................12V'
    2 '............G59 '............Natural Gas'...............12V'
    3 '............G59 '............Liquid Propane'............12V'
    4 '............G59 '............Propane'....................24V'
    5 '............G59 '............Natural Gas'................24V'
    6 '............G59 '............Liquid Propane'............24V'

    And this is only 4 of 34 changing columns...I have broken each column into a different table but all the values must come into one table to create a product, just curious if there is a way of minimizing duplication even with two values in one field

    thank you for your response...that was quick

  4. #4
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    At some point, you still need a tblEngine to put all the parts together.
    You could eliminate some text, but not really any duplication, by
    creating a tblFuel where
    FuelID...FuelDesc
    1.........Propane
    2.........Natural Gas
    3.........Liquid Propane

    Then your example would look like:
    Eng_Num'..Eng_Mod'.......Eng_Fuel'....Voltage'
    1 '............G59 '............1'...............12V'
    2 '............G59 '............2'..... .........12V'
    3 '............G59 '............3'...............12V'
    4 '............G59 '............1'................24V'
    5 '............G59 '............2'................24V'
    6 '............G59 '............3'................24V'

    You would do the same thing for each column that contained "duplicate" data
    Inspiration Through Fermentation

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •