Hopefully a Quick Question!

[jk12]

Hi all, i'm hoping I can get some help.

I am creating a report showing payments to people. The problem i'm having is that on this payment sheet I need to show a value of any brought forward previous payments. I then need to add this payment value to the current payment value to get a grand total. However, i'm not sure of how I can show current payments and previous payments on a report or how to create a way of getting the previous payments onto the report.

I have a query that shows each person and the amount paided to them for each week they worked and I presume this needs to be used somehow to get what i'm after but not sure how.

Thanks for any ideas.

 

[ColinEssex]

You need to calculate the difference between what a person should get v what they do get.

Due £100

Paid £80

= £20 BF

Do that in a query and include that query in the Totals query (linked of course by ID number) adding the 2 together to give you a new total due. Or if you need to show things separately, do it in the report, making sure you have the correct fields you need in the query behind the report.

Col

 

[jk12]

don't think i explained myself well enough. My query at the moment has the name, trade, company, rate, hours worked and cost (rate x hours worked) for each person. The report shows all records (people) for a company and needs a total showing how much is to be paid to that company which is the total of each persons individual cost. So three people cost £100 each so the company is owed £300. However, I also need a box on the report showing a total of all previous payments to that company. I then need another box which adds together the previous payments to the new payments to show a total of all payments to date.

E.g. After 6 weeks X Company has received £1000 (previous payments). This week I have paid £300 in new labour (new payments). Total payments so far therefore are £1300(Total of both which will become next weeks previous payments). Each value shown needs a seperate value box on the report. I can get the new labour value but cant think of a way to get the a total of all previous payments and a way to get the final total to become next weeks previous payments.