Problem adding calculated field to table

[Marina]

I am using Access 2002.

I have a client transactions table with a field for HoursBilled,
BillingRate, and AmountBilled.
Amount Billed is a caluclation of HoursBilled * BillingRate. I can get
it to calculate on the fly in both queries and forms, but need this
number to be in the table.

Anyone have any ideas??

[Rick Brandt]

Re: Problem adding calculated field to table

Marina wrote:[color=blue]
> I am using Access 2002.
>
> I have a client transactions table with a field for HoursBilled,
> BillingRate, and AmountBilled.
> Amount Billed is a caluclation of HoursBilled * BillingRate. I can
> get it to calculate on the fly in both queries and forms, but need
> this number to be in the table.
>
> Anyone have any ideas??[/color]

No, you don't need it in the table and it would be a bad idea to try to put
it there. Use a query with that calculation included in all the places
where you are currently using your table.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[inkman04]

Re: Problem adding calculated field to table

Hello,

Just to back up Rick Brandt, I agree. What you
have been doing is the best way. No need to
save the total when the 2 other primary fields,
HoursBilled & BillingRate, have the data saved
in them for future use. Otherwise a waste of space.

Regards

[Marina]

Re: Problem adding calculated field to table

Thank you!!