+ Reply to Thread
Results 1 to 2 of 2

Creating sub-categories within tables

  1. #1
    Registered User
    Join Date
    10-27-2017
    Location
    New York City
    MS-Off Ver
    2016
    Posts
    39

    Creating sub-categories within tables

    Hi,

    All I am trying to do is simply add data as a subset of existing data inside of a table. I do not need the sub information to be linked to another table because that information doesn't need its own table.

    For example: I have 6 wattages (1-6) of light and 6 color temperatures for each wattage. I just want to record specifications for the 6 color temperatures as a subset of each wattage (Wattage 1 - Color Temp 1, Wattage 1 - Color Temp 2, etc.). I've tried creating relationships but again, I don't need there to be a parent-child link between the 2, I just want the information to be a subset inside of the top level. Please let me know how to do this.

    Thank you.

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,177

    Re: Creating sub-categories within tables

    a table. It dont cost nuthin.

    you can take the tWattage table (1-6) and the tColor table (1-6) into a query
    do NOT join them,
    bring down the fields and add them to the tWattageColor table.
    you will then get 6 colors for every Watt record.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Creating a Macro to sort categories into different sheets
    By jkitfc in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-04-2017, 03:26 PM
  2. Creating a Graph with Series, Categories & Values all in Columns
    By Naton in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-01-2015, 08:04 PM
  3. Creating horizontal line chart with categories in y-axis
    By riya.arora. in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-09-2013, 04:55 AM
  4. Multiple Categories in Pivot Tables
    By polarbottle in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-17-2012, 05:35 PM
  5. creating categories based on time
    By th_ooo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-16-2007, 10:27 PM
  6. Roll down tables - sub categories.
    By dasom in forum Excel General
    Replies: 1
    Last Post: 08-21-2006, 11:55 AM
  7. [SOLVED] Creating Column Headings from XML Categories When Linking Data Wit
    By JimR in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-30-2005, 01:10 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1