user input for report

[Lori]

Hello,

I have this expression in a subreport textbox "Total Personnel with Fringe":
=([AccessTotalsempencumb]+[AccessTotalsemppaid])*1.24

The two totals boxes are above this. The report is grouped by AccountNumber
(report based off of table Account, and subreport off of table
EmpTransactions linked by AccountNumber).

When one opens the report, I would like the user to input any number instead
of "1.24" as it changes yearly (this would be the fringe)
..
I tried putting [Enter Fringe Amount], which was funny because it popped up
that parameter box over 100 times corresponding to the number of accounts, I
presume.

How can I ask for it a fringe amount once?

Thank you kindly,
Lori

 

[KARL DEWEY]

Put your [Enter Fringe Amount] in the query feeding the subreport like
this --
Fringe: [Enter Fringe Amount]

then in the subreport do this --
"Total Personnel with Fringe":
=([AccessTotalsempencumb]+[AccessTotalsemppaid])*[Frimge]

 

[KARL DEWEY]

Typo in last part.

 

[Duane Hookom]

Your data belongs in tables.

I would create a small one record, one field table and use it to store the
Fringe rate. Then add this table to your report's record source (no joins) so
you can use the Fringe value anywhere you want. The users can easily update
the table once per year.

If you want to a little more functionality, you can add a year field and
limit the records to the appropriate year.