T
Tandy
I am currently trying to a make a form to enter the monthly premiums for
each of my employees for each month. In my Employees table, I have Employee
ID, First Name, Middle Initial, Last Name and Termination Date. In my Monthly
Premiums table, I have Employee ID, Premium Month and Premium. I would for
the form to open with a dialog box asking my user to type the month and year
they would like to enter. Then, because the premiums are unlikely to change
from month to month (they change at the beginning of a new year), I would
like the form to list, in a tabular form format, each employee’s Employee ID,
First Name, Middle Initial, Last Name and their Premium for the month before
the one being entered. This is so my user can easily check to see if the
monthly premiums for each employee are right, or change them if they are
incorrect or have changed. It is important that the records for the previous
month are not changed and records for the new month are entered as new
records. I would also like the form to not show Employees with Termination
Date before the month and year being entered. I have been trying to create
this form for a few weeks now but have had no luck in finishing it. Any and
all help will be greatly appreciated!
each of my employees for each month. In my Employees table, I have Employee
ID, First Name, Middle Initial, Last Name and Termination Date. In my Monthly
Premiums table, I have Employee ID, Premium Month and Premium. I would for
the form to open with a dialog box asking my user to type the month and year
they would like to enter. Then, because the premiums are unlikely to change
from month to month (they change at the beginning of a new year), I would
like the form to list, in a tabular form format, each employee’s Employee ID,
First Name, Middle Initial, Last Name and their Premium for the month before
the one being entered. This is so my user can easily check to see if the
monthly premiums for each employee are right, or change them if they are
incorrect or have changed. It is important that the records for the previous
month are not changed and records for the new month are entered as new
records. I would also like the form to not show Employees with Termination
Date before the month and year being entered. I have been trying to create
this form for a few weeks now but have had no luck in finishing it. Any and
all help will be greatly appreciated!