ronniepurpleuk
Registered User.
- Local time
- Today, 00:46
- Joined
- Aug 14, 2006
- Messages
- 16
Hi All,
I'm trying to create a report which shows the profit made on a selection of jobs. It involves 4 tables (invoice details, job details, customer details and hours worked).
The problem I have is when I come to produce a grand total of the amount charged to customers in the report footer. It appears to be including the invoice total more than once where there is more than one set of hours worked.
Eg. a job takes 3 days so there are 3 sets of hours entered - the invoice total for this job is included 3 times in the grand total figure.
It doesn't seem to matter what I do - I can't produce a calculation that will only include the invoice total once for each job.
Can anyone help?
With thanks
Ronnie
I'm trying to create a report which shows the profit made on a selection of jobs. It involves 4 tables (invoice details, job details, customer details and hours worked).
The problem I have is when I come to produce a grand total of the amount charged to customers in the report footer. It appears to be including the invoice total more than once where there is more than one set of hours worked.
Eg. a job takes 3 days so there are 3 sets of hours entered - the invoice total for this job is included 3 times in the grand total figure.
It doesn't seem to matter what I do - I can't produce a calculation that will only include the invoice total once for each job.
Can anyone help?
With thanks
Ronnie