Results 1 to 3 of 3

Thread: ordering a table
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Aug 2009
    Posts
    1,385
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default ordering a table

    This seems quite simple to me but i'm a bit rusty and i just cant figure it out.

    I have a table full of orders (which gets added to) with

    order number/garment type/design type/fabric colour/printing colour/size

    eg:

    10000001/tshirt/frog/green/black/XL

    i want to order them, starting with the most popular items, by colour and design, so ignoring size and order number

    Cant get my head round how to total up each combination and then order them. Hopefully not pivot tables as im not too good with those! VBA and macros would probably be okay though....

  2. #2
    Board Regular
    Join Date
    Aug 2014
    Posts
    54
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: ordering a table

    Hi Merlin,

    You state by colour and design. Which colour (fabric or print?)
    Also the most popular items would imply you have some kind of numerical value assigned somewhere. Where does that sit? Is it how many times 10000001 is ordered or a quantity sitting somewhere which is green/frog?

  3. #3
    Board Regular
    Join Date
    Aug 2009
    Posts
    1,385
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: ordering a table

    Hi marshy. It's the combination of design, fabric color and print colour (so the potential number of combos is huge although only a fraction of them would be practical).
    And there is no quantity column, the order number will be repeated for multiple items.

    I have to say I'm doing this for a friend who already has his table and a lot of data already entered so although I wouldn't do it like this I'm trying to work with it to save him reentering it.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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