Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Nov 2004
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report using a Crosstab Query (Access 2002)

    Edited by HansV to create link to post - see <!help=19>Help 19<!/help>. Note: it would have been better to edit your original post and attach the file, than to start a new thread. See <!help=08>Help 08<!/help> about editing.

    I came across some code (<post#=424177>post 424177</post#>) which I think will work for the report I am trying to create. The reports record source is a crosstab, the reports heading and data will change. My problem is the report I want to create includes many different calucations. I tried modifing the code and I am not able to go further then were I am. I've attached an Excel file which includes the data from my Crosstab, screen shot of the report, the reports code and a sample data of the report I want to create. I need lots of help. PLEASE.

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

    Re: Report using a Crosstab Query (Access 2002)

    Take a look at the database attached to <post#=365977>post 365977</post#>. The report in that database resembles what you want to accomplish:
    - Months as column headings.
    - YTD totals.
    - Group subtotals.

Posting Permissions

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