Hi again
As I am new with Access, I want some help on this basic question which have me pinned in front of this screen for the past two hours.
I'm not sure how to go about and all of my syntax doesn't seem to help
Here's the scenario:
I have a Form displaying in the Page Header, the detail of an employee, Employee Number (EmNr) and Name, based on a selection from the previous form.
In the Detail section, there are entry field for adding and editing the detail of this employee's wage (Date, Rate and Type) stored in a table called WageDetail.
There is also a Subform displaying a filtered list from a Table [WageDeduct] of all the relevant deductions associate with this entry in WageDetail via the fields EmNr and Date.
This normally shows a list of 4 entries.This list also allows you to edit, add and delete an entry.
What I want to do now is to display, in a field at the bottom underneath this list, the total amount of these deductions [TotalDeduct].
I have tried to use a query that calculate these totals by grouping the query first on EmNr and then on Date.
I can't seem to use the correct field or syntax or just maybe am I using the wrong process.
Is there any chance that I can calculate and display the total without using the query and if so, how.
Thanx in advance again
As I am new with Access, I want some help on this basic question which have me pinned in front of this screen for the past two hours.
I'm not sure how to go about and all of my syntax doesn't seem to help
Here's the scenario:
I have a Form displaying in the Page Header, the detail of an employee, Employee Number (EmNr) and Name, based on a selection from the previous form.
In the Detail section, there are entry field for adding and editing the detail of this employee's wage (Date, Rate and Type) stored in a table called WageDetail.
There is also a Subform displaying a filtered list from a Table [WageDeduct] of all the relevant deductions associate with this entry in WageDetail via the fields EmNr and Date.
This normally shows a list of 4 entries.This list also allows you to edit, add and delete an entry.
What I want to do now is to display, in a field at the bottom underneath this list, the total amount of these deductions [TotalDeduct].
I have tried to use a query that calculate these totals by grouping the query first on EmNr and then on Date.
I can't seem to use the correct field or syntax or just maybe am I using the wrong process.
Is there any chance that I can calculate and display the total without using the query and if so, how.
Thanx in advance again
