Total in a report

[Vegaanders]

I have created a small access project to store employees and their salaries and to print out payslips. With the help from this forum, I have solved all problems except one. In the payslip I want to show the total salary paid to the employee during the year. Can this be done?



Regards

Anders

[ranman256]

put the [amtPd] field in the footer of the EMP#
in the source of this field set to : =sum([amtPd])

[pbaldy]

Or use DSum(), if the full year's data is not included in the source of the report, which I'm guessing it's not.

[Vegaanders]

I did and it only shows the current month's salary

Can it be because the query only picks up salary for one month?

Anders

[Vegaanders]

Can you tell a beginner how to write this? The table is Payments and the field is Salary_Euro

[pbaldy]

This should get you started:

DLookup Usage Samples

Using DSum() instead of DLookup().

[Vegaanders]

OK works in a way. The problem is that it shows the total salary for all employees not only the one the payslip is for. The query pick out all employees that have had salary for the month I ask for

Anders

[pbaldy]

Did you add the criteria as shown in the link?

[Vegaanders]

No that part I could not figure out. I understand it the criteria that will solve it but have no clue how.

Anders

[pbaldy]

Well, I can only guess at field names and data types. Something like:

=DLookup("Salary_Euro", "Payments", "EmployeeID = " & EmployeeID)

[Vegaanders]

Well I changed and now I get the same answer again, only the salary for the month the payslip is for. You were almost right, it is Employment_ID

Anders

[pbaldy]

Sorry, cut/paste goof. Try

=DSum("Salary_Euro", "Payments", "Employment_ID = " & Employment_ID)

It occurs you may also need a criteria for this year.

[Vegaanders]

OK now it works if I enter the Employment ID when it asks for it. But with 50+ employees that is not possible. I would like to create all the payslips by answer the question What month

Anders

[pbaldy]

It shouldn't prompt you. Try switching to the full form/report syntax from the link.

[Vegaanders]

Hi!
I realized that the Employment_ID was not in the Query. Now it works. Thanks for all help!

Anders