-
Solved: Upadating from one table to another
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules