| Author |
 Topic  |
|
|
shaneb
Junior Member
USA
319 Posts |
 Posted - 21 March 2002 : 20:02:25
|
I'm trying to make a MS Access dB for the desktop not the web. It's been so long that I really forgot a lot of stuff. Can anyone tell me how to do this.
I am trying to write an expresssion for the control source. I want to add the following expressions:
=Sum([RDSPerClass])+Sum([#Classes])
plus
=Sum([RDSPerStudent])+Sum([#Students])
plus
=Sum([RDSPerRegistration])+Sum([#Registration])
plus
=Sum([RDSPerWeapon])+Sum([#Weapons])
=Total RDS
I am using these expressions in a report in access. The problem is I get a sum for all the above expressions by themselves, but I can't add all of the expressions together to get a grand total becuase this number isn't stored in the dB and Access won't let you store a calculated field.
Anybody know how I can do this.
Thanks in advance!
'Surround your mind and you shall see a great future ahead'
Shane B.
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 21 March 2002 : 23:16:42
|
You should be able to put an unbound control on your form and update it with the values (I think).
Try making a similar report with the report wizard and specify totals & grand totals, you can inspect the resulting report and see how the wiz generated the grand totals.
======
Doug G
====== |
 |
|
|
shaneb
Junior Member
USA
319 Posts |
Posted - 22 March 2002 : 00:08:38
|
quote:
You should be able to put an unbound control on your form and update it with the values (I think).
Try making a similar report with the report wizard and specify totals & grand totals, you can inspect the resulting report and see how the wiz generated the grand totals.
======
Doug G
======
Thanks for replying Doug. Can you be more specific. Are you talking about storing the calculation in the dB so it can show up on the report? If so that's one of the things I can't figure out. How do I do that? What is the expression to use on the form for the control source?
Here is the report so you might be able to understand what I am trying to do. As you can see the expressions I stated earlier help me get the sub-totals, which give the total for the Total RDS Needed. However, I am having trouble adding all of the Total RDS Needed in the report to get a Grand Total to stick in the Report Footer (You See Below In Red). The idea is that the report will print all the following information for 'like' DODICs in this case the DODIC is AA33, then after it finds all of the DODIC's it gives a Grand Total of the Total RDS Needed in the report footer, and then goes on to the next DODIC and does it all over again. This is what I am having trouble with. The report wizard can't calculate sums like this. It adds up all the Sub-Totals with no trouble, but can't add all of the Total RDS Needed to give me a Grand Total. I suspect this is because it can't hold onto the varible, instead all I get is a "0" for the Grand Total. Whew!!!!
I tried putting the report in here, but it didn't look so good. Here is a link to look at it. The Red won't show up, but you will see the tags by Grand Total.
http://www.brass-in.com/report_example.txt
'Surround your mind and you shall see a great future ahead'
Shane B.
Edited by - shaneb on 22 March 2002 00:13:41 |
|
|
| |
Topic |
|
Topic Locked
