Can I calculate different valuse from....???

[tEkHEd]

Hi there..

I am trying to produce a report which will calculate the total amount of installations a software product, grouping by software version...

I have a report which correctly reports the amount of installs. I need to be able to create a section in the Report Header which will total all VERsions together (make sense?)

My report looks a little like:

Manufacturer Product Ver Installs

Department 1
Microsoft Office 95 10
Microsoft Office 97 2
Microsoft Office 2000 100

Department 2
Microsoft Office 95 1
Microsoft Office 97 5
Microsoft Office 2000 50

So what I want to be able to do is total ALL office 95/97/2000 installations across ALL departments..

so at the top of the report I have (in the report header)

Total Installations [ =Sum([Instances]) ]
Office 95 Installations [ I don't know the formulae for this ]
Office 97 Installations [ as above ]
Office 2000 Installations [ as above ]

The issue is that I need to ensure that the total is only for the particular version... can anyone help me out with this??

If you want to take a look at the report design and content to get a better idea, please check here....

http://tekhed.5u.com/cgi-bin/i/Access/rptContent.JPG

http://tekhed.5u.com/cgi-bin/i/Access/rptDesign.JPG

Thanks in adv

 

[CosmoKramer]

Try something like this as the control source for the 95 text box:

=DCount("[Ver]", "YourQueryName", "[Ver] = 95")

 

[tEkHEd]

Thanks for your response CosmoKramer

I didn't go that route though, I just created a subform, and embedded this to give the correct results.