Solved

Math formula on a field for Access report

Posted on 2008-10-22
5
934 Views
Last Modified: 2013-11-28
How do I multiply a numeric field by 100 on an Access report?
0
Comment
Question by:kellyputty
  • 3
  • 2
5 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22780593
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
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 22780663
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
 

Author Closing Comment

by:kellyputty
ID: 31508930
Perfect.  Thanks.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22791386
;-)
0
 

Author Comment

by:kellyputty
ID: 22796236
yup
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question