append/update

  • Thread starter Thread starter Basil
  • Start date Start date
B

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
 
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
 
Back
Top