i've got a table called PAY_TBL that records the pay rate of employees on an
hourly basis. I also have a table called HOURS_WORKED_TBL that records the
hours the employees have worked for. I want to calculate the remuneration for
employees as a calculated field with this function: Wage: [PAY_TBL].[pay
rate] * [HOURS_WORKED_TBL].[hours]. I am storing data in the pay rate field
as text data type, which allows me to use the lookup wizard to define
predifined list values for the this field. since pay rate field is of type
text data type it gives me errors when I calculate wages for employees.
how do I come around this problem while maintaining the same design.
Thanks
.
Re: Saving a subforms calculated fields in a table ... One option is to create a history or log table that records actual payment ... got a raise, you'd multiply the hours prior to the pay raise by the old pay ... e.g. hours worked on a job * an employees pay rate.... (microsoft.public.access.forms)
Re: Saving a subforms calculated fields in a table ...PayRate is changed, all your previous PayAmounts are changed. ... I have a form setup that calculates total rates for time worked on a ... e.g. hours worked on a job * an employees pay rate.... (microsoft.public.access.forms)
Re: writing an expression in the default value property ... If, as I imagine, the subform is a subform of employees on a particular event, you won't be able to do this as a Default Value. ... The Default Value is assigned at the point where a new record is started, and at that point in your data entry, Access can't know which employee, so it can't know which pay rate.... If, on the other hand, the subform is on the Employee form, you could use a DLookup function in the Default Value of the subform's pay rate control.... (microsoft.public.access.forms)
Re: Form for table ... number--that field is linked to the autonumber primary key of the ... the employees. ... In the Northwind example the names show in the field ... Last Name, First Name, but the data type is set for number. ... (microsoft.public.access.forms)
Form for table ... I have three tables that are related by primary keys.... the employees. ... In the Northwind example the names show in the field ... Last Name, First Name, but the data type is set for number. ... (microsoft.public.access.forms)
