Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2006
    Posts
    60

    Unanswered: Creating a 'Matrix' Table

    I want to create wat i think is called a matrix table or something.

    Basically i have different clients and different versions and i have these stored in there own table each. I then want to make another table which puts the clients as the rows, and the versions as the columns, and then i can 'tick' which ones have been setup (as in the clients made to work with the versions). See the picture for an example in excel.

    now im thinking it might not be possible to do exactly as i want. i think i might need a third table to store in it when the thing has been setup (box ticked) and then just use a form to check every field to see if it exists in this third table and if it does show it ticked.

    any ideas? my way seems a bit gay.
    Attached Files Attached Files

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    I would make it like "DemoClientVersionA2000.mdb".
    Look at tables, relationships, query.
    Attached Files Attached Files

  3. #3
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    I agree with MStef-ZG, you can definitely report this using a CrossTab query. In your case you could add a field to the query called Loaded (or whatever) and have it equal to 1. Then when the crosstab is created 1 is put into the fields that the version is loaded.

    Then in the report you can change the 1s to Ys or anything else you want. You could also do it in a query that uses the crosstab as the source.

Posting Permissions

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