Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    195
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Monthly report (XP)

    I would like to use a form in access to report the financial results of my company. I should have the following item as rows: Sales, Gross Profit, Selling Expenses, Administration Expenses and Operating Profit and 13 columns: one for each month plus one for total (see Excel file attached).
    What is the best way to design tables and use queries to achieve this result?
    I know that I can do that in Excel but I would like to centralize my reporting in access.

    Marcel
    Attached Files Attached Files

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Monthly report (XP)

    I would just have enough fields to define the following:
    Field to hold Sales, Gross Profit, Selling Expenses, Administration Expenses and Operating Profit .
    Field to hold Date.
    Field to hold Amount.
    Then a straightforward crosstab query should be used to source the report.
    HTH
    Pat <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    195
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Monthly report (XP)

    Hi Pat,

    thank you for your help. the croostab query works fine.

    Marcel

Posting Permissions

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