Stock Reordering

[JaredNJames]

Hi, i have a table which contains various information about stock.

i have a field which contains a reorder level, which is basically the minimum number of each item to be held in stock at any time. (basically if the stock level drops below this number, the amount below it is, needs reordering.).

example:
reorder level = 3
no. in stock = 2

so 1 needs to be ordered.

Okay, so basically i need to know how i would search the table so that it pulls up the items that need reordering, and exactly how many of each.

any help appreciated

Jared James

 

[boblarson]

Jared:

Create a query that has a calculation of [Reorder Level] - [Number in Stock] and in the criteria have >=1

If the number is negative, or zero it won't show up in the query because you have an amount at or above the restocking level and the results that are returned are the ones that you need.

 

[JaredNJames]

hi, thanks for that, but in my rush i forgot a very important detail:

i dont hold the quantity in stock. i have "total bought in" and "total sold"

i have a query which takes one from the other to give me the number in stock.

so i have the number in stock from a calculation on a query, and the reorder level from the stock table.

any ideas on that one?

jjames

 

[boblarson]

You can just build a query putting the existing query in a new query with the table linked together and then do the calculations I suggested. Let me know if that didn't come through clear.

 

[JaredNJames]

thanks mate. much appreciated.

ive been working on this too long and its fried my brain.

dont suppose you know how to do a sort of general search on a table do you?
basically its the same table, with a list of all the items.

how can i get it so that the user simply enters a word and it searches the table and pulls up any records which match it?

jared james