AdrianK
06-19-2008, 07:29 AM
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
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