Access Report question

K

Keith K

I have a data set I am building regarding our dealerships and their
service capacity. There are 15 different items or so per store and 5
years of data. For certain of the data I would like to create totals in
the report, not however totals for all of the different items. Is there
a way to accomplish this in a report?

I would like the data to layout as follows

Dealer code and name

2005 2006 2007 2008

CP RO's 100
WTY RO's 125
Int RO's 150
Total RO's this needs to be calculated

New Sales 1000
Used Sales 500

Total sold needs to be calulated
 
D

Duane Hookom

You should model this with values stored in fields in records. Perhaps a
field in your table containing "CP RO's", "WTY RO's",,, that identifies that
these have something in common. The same would be true for Sales.

Since you haven't provided any table names or structures or raw data, I
can't be more specific.

IMO, you would not create nested IIF()s or other weird expressions.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access MSACCESS - Sorting report based on field calculated in the report 0
Calculating unduplicated NET totals in reports 1
Summary report 1
How can I create formulas in an access report? 1
ACCESS REPORT DEFINITION - Supress a Group on a Condition? 12
problem creating a report 1
Access report question 1
Report Sums of Sums 1

Top