Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Help with report columns

Discussion in 'Information Technology' started by Flintstone, Jul 28, 2006.

  1. Flintstone

    Flintstone
    Expand Collapse
    Guest

    I have a query called F_Budget which pulls the following information.

    Date Organisation Item Cost

    12.12.2005 Accounts Tax Review $5000
    2.1.2006 Media Advertising $2500
    1.2.2006 Kitchen Catering $6000
    2.3.2006 Accounts Fine $500

    I want to be able to produce a report that would produce the following
    output:

    Reason Date Accounts Media Kitchen

    Tax Review 12.12.2005 $5000
    Advertising 2.1.2006 $2500
    Catering 1.2.2006 $6000
    Fine 2.3.2006 $500

    Totals $5500 $2500 $6000

    The reason I want this report is to keep departmentsa within their
    budgets (I can read the budget targets in from another table and
    highlight it in red if it a department is over budget.)

    How could I produce a report like this that puts the totals in
    different columns depending on the department? I have been looking for
    the answer for a long time, can somebody please help?
     
  2. Loading...


  3. Flintstone

    Flintstone
    Expand Collapse
    Guest

    If you cannot tell which columns line up with which header copy and
    paste the post into notepad in order to read it.
     
  4. kabaka

    kabaka
    Expand Collapse
    Guest

    Create a crosstab query from your query F_Budget (use the wizard to help if
    necessary). Then make a report based on your crosstab query.




    "Flintstone" wrote:

    > I have a query called F_Budget which pulls the following information.
    >
    > Date Organisation Item Cost
    >
    > 12.12.2005 Accounts Tax Review $5000
    > 2.1.2006 Media Advertising $2500
    > 1.2.2006 Kitchen Catering $6000
    > 2.3.2006 Accounts Fine $500
    >
    > I want to be able to produce a report that would produce the following
    > output:
    >
    > Reason Date Accounts Media Kitchen
    >
    > Tax Review 12.12.2005 $5000
    > Advertising 2.1.2006 $2500
    > Catering 1.2.2006 $6000
    > Fine 2.3.2006 $500
    >
    > Totals $5500 $2500 $6000
    >
    > The reason I want this report is to keep departmentsa within their
    > budgets (I can read the budget targets in from another table and
    > highlight it in red if it a department is over budget.)
    >
    > How could I produce a report like this that puts the totals in
    > different columns depending on the department? I have been looking for
    > the answer for a long time, can somebody please help?
    >
    >
     
  5. Flintstone

    Flintstone
    Expand Collapse
    Guest

    Yes, thanks, that is exactly what I wanted.
     

Share This Page