A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

user input for report



 
 
Thread Tools Display Modes
  #1  
Old December 16th, 2009, 08:31 PM posted to microsoft.public.access.reports
Lori
external usenet poster
 
Posts: 673
Default 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  
Old December 16th, 2009, 08:50 PM posted to microsoft.public.access.reports
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default 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  
Old December 16th, 2009, 08:51 PM posted to microsoft.public.access.reports
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default 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  
Old December 16th, 2009, 10:54 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:57 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.