it should be easy but....

S

Silas

WINXP and ACCESS 2K)
Trying to keep track of my items in stock (boat
accessories about
10000items)
Ihave.
Products table (prodID, description, category,
stock,unitsIn,unitsOut)

An Excel sheet imports the table and calculates

netathand=stock+itemsIn-itemsOut.

I'd like to get this calculated values and put them back
to the Access's
products table replacing the values for stock with the
calculated ones,
so next time it is run it would import the new values for
stock so I
always hane the items at hand. How could it be done? Am I
going from
Boston To NY via Denver? Is there a better way? ( I am
not good at
scripts or coding)
Thanks for any help in advance
Silas The Sailor
 
A

Arvin Meyer

always hane the items at hand. How could it be done? Am I
going from
Boston To NY via Denver? Is there a better way? ( I am
not good at
scripts or coding)
Click to expand...

More like via Hong Kong. I'd say Antartica, but you'd have to be storing the
data in Word for that.

Just build a database and do it all there. Calculations take place in query
columns, or occasionally in forms or reports. You don't need much in the way
of coding, but you should be able to write some expressions similar to the
way you do in Excel.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top