Advice needed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is my problem: I manage a ball database which includes 6 different cell
locations in a ball bearing plant. I'm trying to create a query in Access
2000 that will bring up the balls that are under the minimum stock and the
location and then tell me what cell is over the minimum stock for that ball
so I can just move them rater than buying new balls. Any advice?
 
Unfortunately, there's not much advice to give. Without know anything about
your table structures, it's not possible to specify what or how to build the
queries that you need to perform the desired tasks. You may need only one
query, you may need 5 queries. Hard to say.
 
So, are you saying that each ball has six cell locations, each of those cell
locations
with a minimum, and if any of those six cells are under a minimum quantity,
show all the cells,
so you can decide if you just need to move the balls from one cell to
another, or order new ones?

What do your data tables look like?
 
Back
Top