Static Value

[TeeSee]

My customer starts out with 30,000 square feet of an item. My report
shows consumption of that item and totals it in the report footer. I
would like to show the initial 30,000 SF then the totalled consumption
and then the remaining quantity.

How do I enter the value of 30,000 into a text box in order to perform
the remaining calcs.?

 

[Ken Snell \(MVP\)]

You could add a field to your report's RecordSource query so that the 30000
value can be stored in that field, then bind a textbox on the report to that
field. You could even do this as a parameter, letting the query ask you for
the value, if you don't want to use a form to enter the 30000 value:

PARAMETERS [Enter starting amount:] Long
SELECT TableName.*, [Enter starting amount:] AS InitialAmount
FROM TableName;


Then bind a textbox to the InitialAmount field.