Updateing a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Once a month I import a new inventory list for my company, then I copy and
paste it over to another database form, I set it to "no duplicates" because I
don’t want to duplicate anything, but I want the "price" field to update
whenever I do copy it over. I do not have the same amount rows in the 2
forms. I don’t care if its hard but if anyone have any ideas i would really
appreciate it
 
I take it you want to update one or more fields in a table. Normally
you would use an update query. To do this you need to have a field in each
set of data to match on. Do you have such a field (like item number or
unique name?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

create a button to save form in pdf 6
Update query "confirm" question. 2
report with a memo box 2
Recordset is not updatable 3
Getting counts 5
Clarity needed re: compacting a database 11
Copying a split database 1
Append query and combo box on the form 1

Back
Top