Code for saving a calculation in a form to a table field (expanded)

[Guest_imported]

The purpose of saving a calulated field from my form to my table is so that I can use it as a filter criteria. Maybe there is a better way to do this. Everything that I have learned is from Access help screens. I am creating a perpetual inventory DB and I am trying to create a requisition report. I want to tell the report not to reqisition any item with a quantity below the reorder point except those that are on the schedule to be run. I have linked the schedule DB I created to the inventory DB and now I want to tell the form to save either the machine name in a field in the table or say if machine null then result is null else equals date(). Either would work fine then in my query eliminate any records with a machine name or date in that field. I could send you the DB if you want. I'm sure it has many things that were done backwards, but it might help you to see what I am trying to do.

thanks
Scott

 

[Robertd]

So

if exists in schedule AND exists in Inventory
where Inventory.stockQty < Inventory.reOrderLevel

i take it you only want records from the tables if a they have a low stock level and are on the schedule to be reordered. i don't get the machine name or date?

thats if i haven't miss read it?

see ya
RobertD

 

[Guest_imported]

If they are on the schedule to be manufactured that means we have material and do not need to order the material