User Profile

Collapse

Profile Sidebar

Collapse
jannabe
jannabe
Last Activity: Oct 3 '14, 11:49 AM
Joined: Oct 2 '14
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • jannabe
    replied to Count several lookup columns in a pivot table
    in Access
    many many many thanks. At least now I know what to do :-)
    See more | Go to post

      Leave a comment:

    • jannabe
      replied to Count several lookup columns in a pivot table
      in Access
      I've opted for this solution because there can be maximum 5 products ordered but it has to be clear which option and which colour is selected for each product.

      So for instance my products are cars then I need to know for each car which option (eg. sports edition) and which colour (eg. blue) is selected.
      See more | Go to post

        Leave a comment:

      • jannabe
        replied to Count several lookup columns in a pivot table
        in Access
        OK here are the table structures:

        TProduct:
        - ProductID (automatic)
        - Productname (text)

        TOption:
        - OptionID (automatic)
        - Product (lookup of TProduct.Produc tname en TProduct.Produc tID)
        - Optionname (text)

        TColour:
        - ColourID (automatic)
        - Colour (text)

        TMain:
        - OrderID (automatic)
        - Product1 (lookup TProduct.Produc tname)
        - Option1 (lookup...
        See more | Go to post

          Leave a comment:

        • jannabe
          started a topic Count several lookup columns in a pivot table
          in Access

          Count several lookup columns in a pivot table

          Hi,

          I've created a form where a user has to enter a product and corresponding options and colours. He can enter 1 to 5 products with those additional options & colours. The product names and both options and colour lists are separate tables that i've inserted on the form as dropdownmenus with lookup fields.
          So for instance:
          Product1 - Option1 - Colour1
          Product2 - Option2 - Colour2
          ...
          Product5...
          See more | Go to post
          No activity results to display
          Show More
          Working...