Control Source Issue

[rfear]

To save time ( so I thought ) I have designed a database whose forms perform the arithmatic I need and whose tables contain the bare minimum of base data.

In essence I have alot of text boxes displaying values on forms but the values only reside on the form and not in a table.

The problem now is that my boss has decided he wants me to report different data than first requested - the data that is not in a table.

Can I, on my form, keep the arithmetic formula but link the result to a field in my table ?

( So I can reference the field in a query and produce a new report ).

 

[missinglinq]

Assuming that your table(s) contain the base data needed for your report, that's as it should be! You seldom need to store calculated data in a table, simply do your calculations on your report, using unbound textboxes.

 

[rfear]

Thanks. I was hoping to avoid that particular scenario as the calculations are long winded and variable depending on certain scenarios, but if that's what I've got to do then so be it.