Results 1 to 4 of 4

Thread: Access (97)

  1. #1
    New Lounger
    Join Date
    Oct 2002
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access (97)

    I've created a crosstab query...how would I name the (column heading) fields in the query. See attachment.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access (97)

    - What is the field in the column headings (the field with values 1, 2, 3, ...)?
    - How would you *like* to name the column headings in the query?

  3. #3
    New Lounger
    Join Date
    Oct 2002
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access (97)

    The (1, 2, 3, 4...) field is a value field representing products amounts which are in a table. I would need to see the product code for headings. For example: AC12 for the first column, AZ001 for the second etc...

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access (97)

    Assuming you have a table with the product ID's (the numbers 1, 2, ...) and codes (AC12, AZ001, ...), you need to add that table to the design of the query (menu option Query/Show Table...). Probably, the added table will be joined to the one already there on the product ID field; if not, create a join by dragging the product ID in one table to the corresponding field in the other table. Next, in the query grid, replace the product ID field acting as column header by the product code field from the newly added table. That should give you the product codes as column headers

Posting Permissions

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