user input for report

  • Thread starter Thread starter Lori
  • Start date Start date
L

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
 
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]
 
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.
 
Back
Top