Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report- one field may need to change various times

Status
Not open for further replies.

eyhandle

Programmer
Feb 24, 2003
17
US
I have a report. I am showing charges for each record. Sometimes I want all the charges multiplied by 50%. Other times I want all the charges in the report multipied by something else. what is the best way to do this. A pop up box???

ex:
Report w/ 100% of charge
charges
30
20
90
...

Report w/ 50% of charges
charges
15
10
45
...
ect....
 
Create a query from which the report will be based on. Add a new field to the query which will contain a parameter. This will cause a box to appear where you can enter the %. Then, create another field in the query which multiplies the charges by the new parameter field to be % of charges.

Example:

For the new parameter field, it should look something like this:

On the Field Row type: Multiplier: [Please enter discount:]

The next field should have a calculation like:
Discounted: [Multiplier]*[Charges]


Once the query is built like this, you can use the new fields in your report. Each time you run the report, a box will appear requesting the Multiplier number.

Rob



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top