Using a constant in a calculated field in a report 1

[doctorswamp]

Hi all

This may be dead easy.

I want to be able to enter a fixed value for an item called Overhead somewhere in my database, preferably in a Staff form, then use this value in a report that adds up a number of expenses and finally adds the value. The Overhead will be changed every year, and needs to be easily accessible, hence thought of putting it in the form. Having it as the default value for an unbound text box is a bit too technical for the users to change.

So, the report will do a sum([Expenses]) then add the Overhead. Tried referrring to the Overhead as Forms!frmStaff.Overhead but the sum expression won't accept it.

What's best to do? Thanks in anticipation.

 

[lupins46]

Data is held in tables , not in forms.
You can create a table with one record to hold the value.
Use a Dlookup() in the report to retrieve the value.