If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cost Analysis
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 |
#2
|
|||
|
|||
Cost Analysis
"SGTPEP" wrote
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 |
Thread Tools | |
Display Modes | |
|
|