Help with report columns

  • Thread starter Thread starter Flintstone
  • Start date Start date
F

Flintstone

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?
 
If you cannot tell which columns line up with which header copy and
paste the post into notepad in order to read it.
 
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.
 
Back
Top