A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access-How-Inventory with amount and location per part numbe...



 
 
Thread Tools Display Modes
  #1  
Old August 12th, 2004, 04:43 PM
Scott H South Bend, IN
external usenet poster
 
Posts: n/a
Default Access-How-Inventory with amount and location per part numbe...

I would like to setup an inventory data base. This is how we run the
business. We have inventory tags. The information on the tags needs to be
entered. The information I want to database is; part #, location, Quantity
In, Out, and Date. When I do a report I want to see by part # how many is in
a location and also list all locations this part number is in as well as
total inventory of the part #. I can't seem to get access to remove
inventory and then omit a location when it gets to 0 or -value or if we have
two entries of product going in the same location to show as a sum in that
location and not two indiviual entries in the report. We may alsp put more
that one part# ina location. Any help would be approeciated.

Thanks
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:08 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.