Store/Update Value

  • Thread starter Thread starter bw
  • Start date Start date
B

bw

"Total Items" is typically a constant from report to report, but at some point will change.
"Total Items" is not calculated, but is currently entered when the report is run, but I have to
remember the value of "Total Items" each time I run the report.

I don't want to have to remember the value of "Total ITems" but I want to be able to change it's
value from time to time.
How can I store/update the value for "Total ITems" that the report will use for various calculations?

Thanks,
Bernie
 
I would do this with a form. However, you can add an autonumber field and a
Validation Rule that the number must be
<=1

--
Duane Hookom
MS Access MVP
--

bw said:
Is there a way to restrict the table size to allow ONLY one record?

Thanks,
Bernie
Click to expand...
 
I don't think you can do this with an autonumber field, but for just a number field as the key,
what you suggest works perfectly.

Thanks,
Bernie


I would do this with a form. However, you can add an autonumber field and a
Validation Rule that the number must be
<=1
Click to expand...
 
Back
Top