I need help writing a query 1

[shipwreck]

I have two people tracking two different things in two different deparments in two differet building using Access.
One person has a table and he tracks flowers, type, color, etc... some plants are from ohio and some are from mississippi. The other person tracks with prospective gains or incoming flowers. Is there anyway to update the master flower table with a query from the prospective gains flower table?

Master flowers table
Incoming flowers table
can I update the master table was a query???

 

[tlbroadbent]

As long as the tables have a relationship that will allow you to join the them you can update one with data from the other. In general, the query would look like this.

[ignore]Update Master As m Inner Join Incoming As i On m.FlowerID = i.FlowerID Set Inventory = [m].[Inventory] + .[Amount]
Where <criteria to identify Incoming records to apply>;[/ignore]

In order to provide specific response we need to know the tables' structure and relationship. Terry

http://members.home.net/tlbroadbent/prog.htm

_____________________________________
Man's mind stretched to a new idea never goes back to its original dimensions. - Oliver Wendell Holmes

 

[chubby]

Theres no relationship but you can be &quot;SURE&quot; I'll try to make one. Thanks