By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,725 Members | 1,209 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,725 IT Pros & Developers. It's quick & easy.

Stock Database

P: n/a
dan
Hi

I am trying to create a database for a shop with a barcode reader the
problem I have is more than likely a simple one but cant get my head
around it.

the question is how do I create a form that says how many items I have
in stock but will will reduce it when I take one out automatically for
example I have 6 computers I sell one so I want it to say I have 5
left.

I also want t to be able to do a search on a product and know how many
I have in stock is this possable on access?

Kind Regards
Daniel Hardy

Apr 10 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
There is more to that question than meets the eye, as it has to do with
purchase orders, stock received, back orders, sales, and client returns.

For an introduction, see:
Inventory Control - Quantity On Hand
at:
http://allenbrowne.com/AppInventory.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"dan" <da**********@btinternet.com> wrote in message
news:11**********************@t31g2000cwb.googlegr oups.com...
Hi

I am trying to create a database for a shop with a barcode reader the
problem I have is more than likely a simple one but cant get my head
around it.

the question is how do I create a form that says how many items I have
in stock but will will reduce it when I take one out automatically for
example I have 6 computers I sell one so I want it to say I have 5
left.

I also want t to be able to do a search on a product and know how many
I have in stock is this possable on access?

Kind Regards
Daniel Hardy

Apr 10 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.