If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
user input for report
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 |
#2
|
|||
|
|||
user input for report
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 |
#3
|
|||
|
|||
user input for report
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 |
#4
|
|||
|
|||
user input for report
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 |
Thread Tools | |
Display Modes | |
|
|