Grand Total of a Running Sum

[boblarson]

Upload a copy of the database here (with bogus data of course).

 

[vbaInet]

it can't be in the page footer. It DOES make a difference.

Oh yes, that's right. Just remembered you can't sum within the Page footer without vba.

 

[Trodelphin]

cheers for looking at
any input appreciated
only been using access for 2 weeks so go easy on me
think ive sunk 80-90 hrs into it so far tho :/ it's my new WoW
learned SOOO much from here and cpl CD911 courses
big thanks

Report Jobs and Invoice are main ones
form is MainForm

rather proud of my Job Specific Price lookups (took ages to figure that one0

 

[boblarson]

The problem is that you don't have a group footer included. That is where you need your calculation in order to make it work properly.

Also, why do you have the materials report in the invoice report footer?

 

[Trodelphin]

Was only way I could get it to work with proper page layout of
form like such
Heading
Description
Description
Materials
Materials

And page layout sticking

 

[boblarson]

Well, you have some issues with that format.

What is the purpose?

And give me a real example (based on your sample data) of what it should look like.

I don't understand what you are talking about because it is very radically different than any request I've seen before. What is Description? And then are you just looking for a material list or some calculation involving them? If a calculation what is it you want? It looks like your current stuff has the same data in it multiple times here so you have the same calculations for two different things.

 

[Trodelphin]

Work Performed = Description
ok the Form Layout Data should look like so ;
.
Header....
..
Job No..34524..
...
......Work Performed.......Quantity.......Price.......Total
------------------------------------------------
......Grading.......................2..............$10........$20
......Digging.......................1..............$40........$40
......Smoothing...................10............$10........$100
..........................................................Total......
...........................................................$160.....
.
......MATERIALS................LOADS.......PRICE......TOTAL
-------------------------------------------------------
.........Gravel......................3.............$20..........$60
.........Sand........................2.............$50..........$100
............................................................Total.......
.............................................................$160.......
......................
....................................................Grand Total......
......................................................$320.............


All based on the MainForm without Total Fields obviously

 

[boblarson]

What it looks like to me, is that you need two subreports. One for the work performed and one for the materials and nothing for those two on the main report. The main report will be kind of the tie together for them for Job Number.

 

[Trodelphin]

as a general question do you usualy base Forms off Queries or Tables or mix of Both ?
i can see advantages to Both

 

[boblarson]

as a general question do you usualy base Forms off Queries or Tables or mix of Both ?
i can see advantages to Both

You should use a query.