Results 1 to 4 of 4
  1. #1
    gajus21 is offline Novice
    Windows 10 Access 2007
    Join Date
    Feb 2019
    Posts
    2

    Calculations in report

    Hello,
    I have a question about calculations in Reports. I want to multiply value from one column to another but I have a connection value from other table and if I make:
    =[Test1]*[Test2] I have some strange score.

    Even if I do something like this =[Test1] I have only value from ID numbers.

    I have a request how can I multiply value from two deferent tables?

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Join the two tables in a Query.
    Whenever possible, I prefer to do most of my calculations at the Query level too, so do all the ones you can there (via a Calculated Field).
    You can use those Calculated Fields in your Report, if you base the Report off of the Query.

  3. #3
    gajus21 is offline Novice
    Windows 10 Access 2007
    Join Date
    Feb 2019
    Posts
    2
    OK I have a other question because I add to table a field: "Lookup column" all is good I do not have a problem when I make table.
    But when I make calculations my use to calculate "Id key" not the value with I chose. Where is the problem? Maybe I should use some additional formula in my text:
    =[Field1]+[Field2]

  4. #4
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    You should add Calculated Fields in a Query, not in the Table.
    While newer versions of Access allow you to add Calculated Fields to Tables, it is recommended that you not add them there, for various reasons such as:
    - it violates the rules of Data Normalization
    - no other database programs allow this (so if you had to convert this to something like SQL at some point in the future, it would not work)
    - the types of calculations you can do are limited

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Report based calculations
    By Rangerguy2000 in forum Reports
    Replies: 24
    Last Post: 12-13-2018, 02:30 PM
  2. Report Calculations incorrect.....why?
    By CBRRider1 in forum Reports
    Replies: 12
    Last Post: 03-08-2014, 12:15 AM
  3. Formatting calculations on a report
    By Nashskye13 in forum Reports
    Replies: 1
    Last Post: 12-12-2012, 03:52 PM
  4. Incorrect Calculations in Report
    By Bridiewms in forum Reports
    Replies: 6
    Last Post: 01-30-2012, 10:28 AM
  5. Creating a report with calculations
    By Normantom in forum Queries
    Replies: 1
    Last Post: 05-07-2010, 06:29 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums