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?

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