can't total my total!

[ukmgranger]

Hi there,

My database has essentially 3 tables.

Table 1:

holds company expenses (not individual job based expenses)

Table 2:

holds job details (client details, hours worked on that job portal with expenses etc.)

Table 3:

job expenses (petrol, transport etc.)

I have a portal in 'table2' to show the jobs expenses which almost works fine.

The problem that I have is that I want to see a running total of the job expenses.

I have created a summary in 'table3' that displays this fine. I just can't seem to get it to display in 'table2' though. It only ever seems to display the total of the current record.

Any ideas?

[aaa]

Can you attach part of your file for understanding your question?