Access Reports

  52MikeH 08:56 03 Dec 2005
Locked

I have a report in wich each line has productdescription,units held,unit value,Units held Value (which is a calculated text box 'units held*unit value' )
In the report footer I would like to show the Total value of all stock ie a sum of the Units held value.
How would I do this as everything I try does not seem to work !

Mike

  Access genu 09:49 03 Dec 2005

Put an additional text box in the details section of the report, Call it txtDetailsSum

set the control source for this to be the the name of the text box that contains the value of each line (=[txtLineCost])
Set the running sum in the data tab of the box to over group.

Preview the report, this text box should now be adding up the totals

After the details section add two extra box's
the first on is for the totals over the group, the second one is for the overall totals.

Test the control source for both as = [txtDetailsSum]

call one txtSumGroup and set the running sum in the data tab of the box to over group.

Preview the reoprt, you should now have two totals, on over each detal section and a running one over the group.

Create a new text box in the report footer and set its control source to = [txtSumGroup ]and set the running sum in the data tab of the box to over group.

Now set the visible property of all the extra box's to false.

  52MikeH 11:42 03 Dec 2005

Thanks Access genu,
Works perfect !

Mike

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

6 great UX design talks you can watch online

How to jailbreak an iPhone or iPad in iOS 11 or iOS 10

Musique de Noël : les meilleures chansons en streaming