Access, Excel, Inventory data base help.

[Mr. LL]

I need a simple data base to keep track of inventory items, mainly just simple data like cost, taxes, shipping, sales price and profit.

I have a Access DB started up and everything seems fine and I can get a over all sum of items from the top down but if I want it to autofill, like I have on colum that is purchase price, the next one is tax, the third one is total, how can I make it auto add or subtract within the same row?

Maybe it would be easier to use excel for what I need but I would rather use Access since it seems like it is a lot more powerful for DB's

Any other ideas or suggestions on inventory software? One day I will plop down for an expensive ap if I need it but until then I need to get by.

 

[Hefemeister]

http://office.microsoft.com/en-us/access/HP051879071033.aspx

That should give you some ideas.

 

[Mr. LL]

Thanks, I'll check that out.