Updateing a column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Harleyi - 12 Sep 2007 17:44 GMT

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

Reply to this Message

Joseph Meehan - 12 Sep 2007 19:30 GMT

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?

Signature

Joseph Meehan

Dia 's Muire duit

> 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"
[quoted text clipped - 4 lines]
> really
> appreciate it

Reply to this Message