Simple calculation box

[jordz]

I am currently trying to create a calculation box that will sum up the total amount of money that each employee has got. I have tried to do it but end up with a total of all of the data in the report, rather than of each specific person. It is also coming up under every price, and if one employee has many sales, then this does not help. From this picture, you can see that the first employee has 2 separate sales but the totals box is under both of them. I am by far an expert on access as I have only just recently started to use it and trying to learn, but if there are any simple things to do to help me sort this out, it would be much appreciated.Regards,Jordan

[aytee111]

Use the report wizard to create the report. Use the grouping and summary options to create the totals. It will ask you how you want it designed and you can answer the questions and select the totalling.