counting current items on hand

[fleury]

HI all i'm new to access 2007 and learning all by myself. I would like to creating two tables, one with item in and the other wif item out.

There are many different item numbers for the items in my tables. and I would like to know the current items on hand. I need some guidance to continue with my project.

THANKS in advance!!!

 

[GinaWhipp]

See if this helps...

http://allenbrowne.com/AppInventory.html

 

[fleury]

can i do tat without much coding?

 

[GinaWhipp]

I don't know... you may be able to accomplish what you want using queries but without knowing youe table structure hard to say...