Code for saving a form calculation in a table field

[Guest_imported]

Can anyone tell me what code I would have to enter to save a calulation in a for in a table field.

Thanks

 

[kathryn]

If I understand the question, you want to save the calculation you use in a control on a form into a table. Do you want to save the actual calculation ("=sum(field1)&quotor the results (427)? Generally, you shouldn't save calculations in tables; they take up space unnecessarily. However, sometimes there are reasons to do so.

There are a number of approached to do this; if you could provide a bit more detail of what you are doing and why, I'm sure that we could help you out.

 

[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