Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Math formula on a field for Access report

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

Expert Comment

by:Jeffrey Coachman
ID: 22780593

Assume you have a textbox called: txtSales

-Make a new textbox.
-Set the control source of this new textbox to:

LVL 74

Accepted Solution

Jeffrey Coachman earned 2000 total points
ID: 22780663

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.



Author Closing Comment

ID: 31508930
Perfect.  Thanks.
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22791386

Author Comment

ID: 22796236

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

578 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