Recent content by darrenay

Hi RuralGuy, Thanks for the tip. I have now removed all the spaces in my field names. Adding the square brackets didn't help. I did a test to see what is wrong and I think I have narrowed it to SUM. I tested with formula: =[Subform1].[Form].[Quantity] I managed to get a number returned...

Hi all, I have a subform "Line Items" embedded in my main form "Transaction". The Line Items subform has a field "Amount Payable" and I am trying to sum this up for all the line items. The calculated filed would be named Sub Total. However, i kept getting an error message "#ERROR". Main...