Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Counting Functions (A2K)

    A reasonably simple problem once you
    Cheers,
    Andy

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

    Re: Counting Functions (A2K)

    Create a query based on the table with the PartNo and FnctnCode fields.
    Select View | Totals or click the Totals button on the toolbar.
    Add the PartNo field to the query grid and add the FnctnCode field twice to the query grid (no, that's not a mistake).
    Leave the Total option for the first two columns as it is (the default Group By).
    Set the Total option for the third column (the duplicate FnctnCode) to Count.

    Switch to datasheet view to see the result.

    For a different presentation of the same information, switch back to design view.
    Select Query | Crosstab Query.
    Set the crosstab option for the three columns to Row Header, Column Header and Data, respectively.

    Switch to datasheet view to see the result.

  3. #3
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Counting Functions (A2K)

    Hans,

    Absolute clear explanations! I've always had problems with crosstabs even with Wizards and browbeating error messages. I tried the manual version first and got pretty near what I wanted, but then applied the same layout when doing the Crosstab Wizard and got exactly what I need. Thanks again
    Cheers,
    Andy

Posting Permissions

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