what type of querie

[tubar]

I have a querry that totals all my light bulb orders. Every month I do an inventory of whats on the shelf…(keep in mind that number doesn’t need to be stored it is just inputed on a form) I want to take that number (we will call it shelf number) and lets give it a value of 50…can I subtract [shelf number] from [order total and say that number is 100] Is it possible to create a querry that then inputs a record with the answer of 50

 

[speakers_86]

If you have a field called [AmounttoOrder] and you want it filled in automatically, then turn your calculation query into an update query. Keep in mind that calculations are generally not stored.