Hello,

I have 2 tables:

dbo_pmf (including columns qpc & short_name)
dbo_spt (including spt_sptlvl_val & spt_lvl_desc)

I am not sure if this is even possible, but I want to update the spt_lvl_desc column in dbo_spt, using the value from short_name in dbo_pmf, where qpc = spt_sptlvl_val.

I am using MS access.

I've tried various options, but can't seem to get it to work.

Is it possible, and can anyone help me??

Many thanks,

Adrian