Results 1 to 2 of 2

Thread: Crosstab query

  1. #1
    Join Date
    Sep 2002
    Location
    USA
    Posts
    66

    Unanswered: Crosstab query

    I have a field CovType with combo boxes PO1, PO2P14. I like to design a report to indicate the total number of PO1, PO2, PO3.for each month (Jan. Feb. Mar. etc.) and the total count for the whole year. How can this be accomplished and do I need to design a query first.
    Thanks,

  2. #2
    Join Date
    Apr 2002
    Posts
    139

    Re: Crosstab query

    Design a CrossTab query first, make sure to include a date field somewhere to reach the months.

    Then design your report based on the query, and let the report wizard calculate totals in different directions.

    hth

Posting Permissions

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