Calculated Fields in Access 2002 queries

[Guest]

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

 

[Guest]

Hi Wellcome,

you should try the following (it takes the numeric value of a text field) :

[PAY_TBL].[pay rate] * VAL([HOURS_WORKED_TBL].[hours])

hope it works,
mischa