Solved

Calculation on a field

Posted on 2015-01-30
6
74 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
Comment Utility
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
Comment Utility
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
Comment Utility
...Then you should be able to reference the "value" as I stated, something like this:
    =Forms!YourFirstForm!txtBigCalc
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:Jass Saini
Comment Utility
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
Comment Utility
I add the calculation to my query
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
Comment Utility
Glad I could help.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
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…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now