I have a column with a sum total in the footer. I would like to subtract this calculated number from a constant (ie 20,000.00). Is this possible?
I have a column with a sum total in the footer. I would like to subtract this calculated number from a constant (ie 20,000.00). Is this possible?
Sure; try either:
=20000 - [TextboxName]
=20000 - Sum(FieldName)
Is there a way to code a field so that it remains a constant number (currency amount)?
in your query yes
Just have something like
Constantvalue: 40000
then every line of your query will have a value of 40,000 in a field called ConstantValue