I'm not sure how to describe the problem, it's probably something very simple but it's only simple if you know it. I've created a form which is linked to a table. Most of the boxes within the form require user to input the data manually e.g date, order number, spec number etc.
However I've changed the control source on some of the boxes and replaced it with a formula e.g "=1+1". Access calculate the result for me e.g "2" but does not record this information in the table.
The problem I've got is that eventually I'd like to filter the data within the table or run a quote but one of the criteria may be the result of the formula.
So if I specify in the quote that i want to see all records within a specific range lets say "25-30" there will be no results as the column that column is blank.
Could you please help me with this?
I would appreciate any advise.
Thank you