I have 2 simple tables.
employee and payroll. i created the employee table and payroll via a form.
so for each employee, there will many records of payroll.
the tables are connected via employeeID as a REF key.
in the payroll table, there are the following columns being recorded for each employee.
each employee will be recorded a row each day for their INCOME and TIPS.
eventually, the payroll table will have many rows by DATE.
so at the end, i want to have select an EMPLOYEE and a range of the DATE, like the FROM and TO DATE to select from, to sum up their INCOME and TIPS.
can i read from both tables, EMPLOYEE and PAYROLL, to retrieve the records where the DATE is between the certain range and SUM up the INCOME and TIPS?
please let me know if i am not explaining it correctly for your understanding.