Cost Analysis

[SGTPEP]

I am trying to create a report which performs an analysis of the cost of
running an event.

I want the report/pivottable to be split into 2 sections, income and
expenditure. Within each section there will be 3 further fields. I want a
total of each field and totals of each section,leading to an overall profit
or loss.

What would be the most efficient way of going about this?

Design a report or a pivottable, so far i have found neither to be very
efficient.


Thanks

 

[Larry Linson]

I am trying to create a report which performs an
analysis of the cost of running an event.

I want the report/pivottable to be split into 2 sections,
income and expenditure. Within each section there will
be 3 further fields. I want a total of each field and totals
of each section,leading to an overall profit or loss.

What would be the most efficient way of going about this?

Design a report or a pivottable, so far i have found
neither to be very efficient.

Are you asking for application design assistance, or how to implement a
report?

If the latter, we'll need to know what data you have, and how you have it
structured into tables.

If the former, if you provide a slightly more comprehensive summary of
requirements, someone may be able to give an overview that will "point you
in the right direction." A complete, detailed application design is, of
course, too extensive for a newsgroup response.

With properly structured (normalized) data, I have found Pivot Tables to be
useful (to put them in Reports, you need to create the Pivot Table as a
Form, and embed the Form in a Subreport Control). But, from the very sketchy
description of what you want, it's not clear to me that you have a
requirement that Pivot Tables would be needed to satisfy.

And, in nearly 50 years in the computer business, I've never found _any_
report generator as efficient and effective as Access', whether standalone
or part of a product. Do you have a candidate for a "more efficient" report
generator?

Larry Linson
Microsoft Access MVP