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
|
|||
|
|||
calculated field from sub form datasheet
My form has this format:
1) Main form...Single form - sub-form1.....datasheet - sub-form2......datasheet sub-form1 has a numeric field: Order sub-form2 has numeric field: Received I need a field in sub-form1 to calculate the total of [sub-form2].[Received] and compare it to 'Order' so I know when the order has been completed. I have tried a field 'subTotal' in the footer of sub-form2: '=sum([Received]), but when I put a reference to 'subTotal' in sub-form1 I get '#Error'. Thank you for your help! |
#2
|
|||
|
|||
calculated field from sub form datasheet
You can try this format:
=Forms![main form]![sub-form2].Form!sub-form2 This usually works for me. -- Amy E. Baggott "I''m going crazy and I''m taking all of you with me!" -- Linda Grayson "segurarl" wrote: My form has this format: 1) Main form...Single form - sub-form1.....datasheet - sub-form2......datasheet sub-form1 has a numeric field: Order sub-form2 has numeric field: Received I need a field in sub-form1 to calculate the total of [sub-form2].[Received] and compare it to 'Order' so I know when the order has been completed. I have tried a field 'subTotal' in the footer of sub-form2: '=sum([Received]), but when I put a reference to 'subTotal' in sub-form1 I get '#Error'. Thank you for your help! |
#3
|
|||
|
|||
calculated field from sub form datasheet
Thank you!
I have tried it before but it doens't work when I try to get the total the value on the field "Amy E. Baggott" wrote: You can try this format: =Forms![main form]![sub-form2].Form!sub-form2 This usually works for me. -- Amy E. Baggott "I''m going crazy and I''m taking all of you with me!" -- Linda Grayson "segurarl" wrote: My form has this format: 1) Main form...Single form - sub-form1.....datasheet - sub-form2......datasheet sub-form1 has a numeric field: Order sub-form2 has numeric field: Received I need a field in sub-form1 to calculate the total of [sub-form2].[Received] and compare it to 'Order' so I know when the order has been completed. I have tried a field 'subTotal' in the footer of sub-form2: '=sum([Received]), but when I put a reference to 'subTotal' in sub-form1 I get '#Error'. Thank you for your help! |
Thread Tools | |
Display Modes | |
|
|