Search results

The way the database is setup is there are say 20 employees which belong to one of the 5 dept in the Department list. So when a user goes in to enter timesheet info they will choose the Employee from the list and we would like to default the dept field in the form to the dept. that is defined in...

I am having problem putting a default value in a field based on the entry of the previous field. We have an Employee table that contains Employee info plus its Department key. Then we have a Department table that contains the Department code and description. I would like to default the...

I did the IIf and got the results to show on the form. That is great. Now I need to save the data to the field in the table. As it stands I can view the results but it is not stored. How do I store the value in the table?

More specifics I have a table that contains 'Employee Name', 'Employee Department', 'Exempt' tickbox, 'Regularpay' and 'Overtimepay'. What I need to setup is if the 'Exempt' is ticked then calculate the 'Overtimepay' by 'Regularpay'*1.5

I am new at this. I have a database table emp with a check box for "Exempt" employees. I have a form "Enter time card" that is a data entry and would like to automatically populate the overtime field with the value of regtime*1.5 if the check box is ticked. I am having trouble doing this...