If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#Error on Sum Formula from Subform
Hello, I have this formula on the subform =IIf([PICK]=True,Nz([DUE SHIP]),0).
Now, on the main form, I want to sum the result of this condition. I keep getting a #Error, helpppppppppppppp! Thanks all. |
#2
|
|||
|
|||
#Error on Sum Formula from Subform
What kind on field is [PICK]?
"JavyD" wrote: Hello, I have this formula on the subform =IIf([PICK]=True,Nz([DUE SHIP]),0). Now, on the main form, I want to sum the result of this condition. I keep getting a #Error, helpppppppppppppp! Thanks all. |
#3
|
|||
|
|||
#Error on Sum Formula from Subform
Javy,
You didn't mention how you are going about getting the sum of this calculated control onto your main form. But I think you will need to do the sum in a control in the Header or Footer of the subform, and then reference *that* control on the main form. In other words, let's say you put a TotalWhatever textbox on the subform, with its Control Source like this... =Sum(IIf([PICK],Nz([DUE SHIP],0),0)) .... and then, the control on your main form like this... =[NameOfSubform]![TotalWhatever] If you still need more help, please give some more details of what you've got there. -- Steve Schapel, Microsoft Access MVP JavyD wrote: Hello, I have this formula on the subform =IIf([PICK]=True,Nz([DUE SHIP]),0). Now, on the main form, I want to sum the result of this condition. I keep getting a #Error, helpppppppppppppp! Thanks all. |
#4
|
|||
|
|||
#Error on Sum Formula from Subform
Good Question, Pick is a Yes/No field
"KARL DEWEY" wrote: What kind on field is [PICK]? "JavyD" wrote: Hello, I have this formula on the subform =IIf([PICK]=True,Nz([DUE SHIP]),0). Now, on the main form, I want to sum the result of this condition. I keep getting a #Error, helpppppppppppppp! Thanks all. |
#5
|
|||
|
|||
#Error on Sum Formula from Subform
Ok, on the mainform I have the subform, what this subform has is order
numbers and products on that order. Some I want to ship and some I dont. What I have is a checkbox for each line on the order, that when checked, it means that I want it to ship. What I want, is this control to not sum, but to just populate in the instance that that specific item will be picked, else stay at 0. Now on the main form which has a link to the subform by PO number. I want to add all of the ship qty by line on that order that will being shipped. Is that a better explanation? "Steve Schapel" wrote: Javy, You didn't mention how you are going about getting the sum of this calculated control onto your main form. But I think you will need to do the sum in a control in the Header or Footer of the subform, and then reference *that* control on the main form. In other words, let's say you put a TotalWhatever textbox on the subform, with its Control Source like this... =Sum(IIf([PICK],Nz([DUE SHIP],0),0)) .... and then, the control on your main form like this... =[NameOfSubform]![TotalWhatever] If you still need more help, please give some more details of what you've got there. -- Steve Schapel, Microsoft Access MVP JavyD wrote: Hello, I have this formula on the subform =IIf([PICK]=True,Nz([DUE SHIP]),0). Now, on the main form, I want to sum the result of this condition. I keep getting a #Error, helpppppppppppppp! Thanks all. |
#6
|
|||
|
|||
#Error on Sum Formula from Subform
Javy,
Did you try the idea that I suggested before? Did it not do what you wanted? If not, I think I understand your explanation, but not how it relates to your original question. Try giving an example. Example means actual data from your form, and expected results in specific numbers. Thanks. -- Steve Schapel, Microsoft Access MVP JavyD wrote: Ok, on the mainform I have the subform, what this subform has is order numbers and products on that order. Some I want to ship and some I dont. What I have is a checkbox for each line on the order, that when checked, it means that I want it to ship. What I want, is this control to not sum, but to just populate in the instance that that specific item will be picked, else stay at 0. Now on the main form which has a link to the subform by PO number. I want to add all of the ship qty by line on that order that will being shipped. |
#7
|
|||
|
|||
#Error on Sum Formula from Subform
It's ok Steve, thanks for your help, I think you answered this already in
another post. I just placed the expression in the query, then the sum control in the footer of the subform, then on the form I did the reference to the subform, worked fantastic. Thanks again. "Steve Schapel" wrote: Javy, Did you try the idea that I suggested before? Did it not do what you wanted? If not, I think I understand your explanation, but not how it relates to your original question. Try giving an example. Example means actual data from your form, and expected results in specific numbers. Thanks. -- Steve Schapel, Microsoft Access MVP JavyD wrote: Ok, on the mainform I have the subform, what this subform has is order numbers and products on that order. Some I want to ship and some I dont. What I have is a checkbox for each line on the order, that when checked, it means that I want it to ship. What I want, is this control to not sum, but to just populate in the instance that that specific item will be picked, else stay at 0. Now on the main form which has a link to the subform by PO number. I want to add all of the ship qty by line on that order that will being shipped. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Update combo box in subform (After Update event) | Karl | Using Forms | 10 | April 4th, 2006 07:45 PM |
Formula checking multiple worksheets | sonic-the-mouse | Worksheet Functions | 11 | June 6th, 2005 06:37 PM |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |
Need help with cascading combos | Tom | Using Forms | 19 | July 1st, 2004 11:11 PM |
Recordset in subform based on field in parent form | Lyn | General Discussion | 15 | June 14th, 2004 03:10 PM |