• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 951
  • Last Modified:

Math formula on a field for Access report

How do I multiply a numeric field by 100 on an Access report?
0
kellyputty
Asked:
kellyputty
  • 3
  • 2
1 Solution
 
Jeffrey CoachmanMIS LiasonCommented:
kellyputty,

Assume you have a textbox called: txtSales

-Make a new textbox.
-Set the control source of this new textbox to:
    =[txtSales]*100

JeffCoachman
0
 
Jeffrey CoachmanMIS LiasonCommented:
Kelly,

Just a note here.

Things like this are better handled in the Reports RecordSource.

In other words you should base the report on a query.
The query will contain a "Calculate Field" that performs your needed math.

For example:
SELECT Sales, SaleDate, SalesPerson, [Sales]*100 AS Sales100  FROM tblSales

This way the calculated field is available when you create a Report or form.

This way you do not have to create it over and over again for each new Form or Report.

:-)

JeffCoachman
0
 
kellyputtyAuthor Commented:
Perfect.  Thanks.
0
 
Jeffrey CoachmanMIS LiasonCommented:
;-)
0
 
kellyputtyAuthor Commented:
yup
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now