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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200611/1

You need two queries - one append and one update.


"bastraker via AccessMonster.com" wrote:

> 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
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...eries/200611/1
>
>

"Klatuu" <(E-Mail Removed)> wrote in message
news:EE5237A7-2A87-44D1-BA02-(E-Mail Removed)...
> 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

>
>
> "bastraker via AccessMonster.com" wrote:
>
>> 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
>>
>> --
>> Message posted via AccessMonster.com
>> http://www.accessmonster.com/Uwe/For...eries/200611/1
>>
>>

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


"Tom Lake" wrote:

>
> "Klatuu" <(E-Mail Removed)> wrote in message
> news:EE5237A7-2A87-44D1-BA02-(E-Mail Removed)...
> > 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
>
> >
> >
> > "bastraker via AccessMonster.com" wrote:
> >
> >> 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
> >>
> >> --
> >> Message posted via AccessMonster.com
> >> http://www.accessmonster.com/Uwe/For...eries/200611/1
> >>
> >>
>
>
>

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

Tom Lake wrote:
>> 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

--
Message posted via http://www.accessmonster.com

"Klatuu" <(E-Mail Removed)> wrote in message
news4CFC631-8FD0-44E0-AB20-(E-Mail Removed)...
> 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