Solved

Calculation on a field

Posted on 2015-01-30
6
76 Views
Last Modified: 2015-02-03
Hello,

On my first form I have a calcualation field ..I need to carry that field into my second form...All these fields are on the table.

I was told to use the same calculation on the second form but just add the table name in front of the fields as these fields are not on the second form.

Can it be done this way?  All these fields are on my first form:

=Nz([Total Initial:],0)+Nz([BC1Chng1],0)+Nz([BC1Chng2],0)+Nz([BC1Chng3],0)+Nz([BC1Chng4],0)+Nz([BC1Chng5],0)+Nz([BC1Chng6],0)+Nz([BC1Chng7],0)+Nz([BC1Chng8],0)+Nz([BC1Chng9],0)+Nz([BC1Chng10],0)
0
Comment
Question by:Jass Saini
  • 3
  • 3
6 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40580980
carry that field into my second form.
Carry the Calculation or carry the value?

If the value, then just reference the control itself?
For example, ...If the control that holds your calculation is named "txtBigCalc"
Then simply make the control source of a textbox in the second form:
=Forms!YourFirstForm!txtBigCalc



You will have to explain what you are doing here a bit more (and explain why...)
Is the second form a subform or a standalone form?
0
 

Author Comment

by:Jass Saini
ID: 40584191
Hello,

I have an ending calculation on the first form that has to be the starting calculation on the second form..kind of like a ending balance and the second form is the beginning balance.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 40585352
...Then you should be able to reference the "value" as I stated, something like this:
    =Forms!YourFirstForm!txtBigCalc
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:Jass Saini
ID: 40586752
It gives me a #Name? error


I tried the subform name and the main form..niether work for some reason
0
 

Author Comment

by:Jass Saini
ID: 40586879
I add the calculation to my query
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40586985
Glad I could help.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

810 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