up date query...

[londonworker]

I need to set up an update query for stock levels. How do I go about doing this? (this should be up-dated directly from the database window)

 

[andrew93]

Hi
This webpage might help.
Andrew

 

[Pat Hartman]

that's an excellent link andrew but the answer really is - do not attempt to manage your inventory this way. There are numerous posts here on this topic, some from this week.