append/update

[Basil]

Hiya,

I ain't too good with append/update queries. I just don't
like them.

I have a table: Referrals - which has a unique referral
key.

I created a query that assigns (through calculations)
certain results in a [referral result] field. How can I
add this field to the original referral table?

Thanks,

Basil

 

[Kelvin]

Add this field in the table design first. Then perform an update query on
this table where you update this new field to your equation.

Kelvin