Results 1 to 2 of 2
  1. #1
    rob4465 is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2010
    Posts
    4

    Query - Crosstab ?

    Hi Good Morning,



    I currently have a query that displays six columns:

    Company | Product1 | Product2 | Product3 | Product4 | Product5

    So one row displays one company with five different products.

    What I need is some kind of query that will display the data like this:

    Company | Product1
    Company | Product2
    Company | Product3
    Company | Product4
    Company | Product5

    Basically the same company would be shown five times (on different rows) with the different Products on each.

    I'm sure there's a way to do this with a crosstab but I could do with some new ideas as I'm in a rut !

    Thanks very much in advance for your assistance.

  2. #2
    jbarrum is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Apr 2009
    Location
    Houston, Tx
    Posts
    164
    Sounds like you have a normalization problem. You should be storing companies and products in two differnt tables and a third table would store what products each company carries.

    Espcially if you have two different companies that carry the same product. If you are not familiear with normalizaton you should read up on it. It will help you go a long way in designing your database and minimize problems with it down the road.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. crosstab query criteria
    By Sharron in forum Queries
    Replies: 3
    Last Post: 12-15-2011, 04:31 AM
  2. Parameter in Crosstab Query
    By RandyG in forum Queries
    Replies: 4
    Last Post: 09-30-2009, 06:40 AM
  3. crosstab query calculation
    By rutica in forum Queries
    Replies: 2
    Last Post: 04-28-2009, 09:52 AM
  4. Criteria in Crosstab Query
    By wasim_sono in forum Queries
    Replies: 1
    Last Post: 12-12-2006, 05:14 AM
  5. Replies: 2
    Last Post: 11-09-2005, 02:51 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums