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]

-- 
Build a little, test a little.


"Lori" wrote:

> 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

Typo in last part.
-- 
Build a little, test a little.


"Lori" wrote:

> 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

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.

-- 
Duane Hookom
Microsoft Access MVP


"Lori" wrote:

> 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