Append, Update, Both?!?!?

[bastraker via AccessMonster.com]

Hello All

Wondering if anyone has some insight into my latest dilemma. I'm building a
database to handle stock quantities and location.

So I have a table, Kit_Quantities, with the fields Part_Number(key),
Project_Name(key), Location, Quantity, and Checked_Out. If a user needs to
take stock out he will mark the Checked_Out field, could be multiple line
items that must be checked out at once. My problem is when the users returns
stock he may now have additional items not in the database.

I would like to be able to import the returning data from an excel
spreadsheet into an initial table then run some sort of append/update query
that will add the new line items and for any primary key matches(i.e.
returned stock) update the fields as long as the Checked_Out field is marked.

Any assitance would be greatly appreciated.
D

 

[Guest]

You need two queries - one append and one update.

 

[Tom Lake]

You need two queries - one append and one update.

Not in Access SQL. One query does both. I use that
technique all the time.

Tom Lake

 

[Guest]

I'm sure you do, but you are knowledgable and experienced.

 

[bastraker via AccessMonster.com]

Thanx Tom I actually found one of your previous posts on the subject and it
works like a charm!!!

You need two queries - one append and one update.

Not in Access SQL. One query does both. I use that
technique all the time.

Tom Lake

Hello All
[quoted text clipped - 19 lines]
Any assitance would be greatly appreciated.
D

 

[Tom Lake]

I'm sure you do, but you are knowledgable and experienced.

Aw, shucks. A big Barrada Nikto to you, too!
If I spelled it wrong it's because Gort won't tell
me what the correct spelling is. He opens his
visor as if he's going to say something, but
only a Laser beam comes out. 8^(

Tom Lake