Please Help with Sum Of Calculated Fields in SubForm

[Kroghr]

Please Help! This is my first attempt at access. I've gotten this far from what I've been ble to learn from this forum. I'm attempting to create a Aircraft Weight and Balance Databse. I'm stuck trying to sum Calculated fields ZeroFuelWeight and FuelWeight in my Subform. Any help or comments on my Database would be greatly appreciated

 

[John Big Booty]

Try using;

=Int(([Forms]![MetrolinerFlightManifest]![AircraftNumber].[column](3)))+Int(([Forms]![MetrolinerFlightManifest]![FuelWeight].[Column](1)))

I'm guessing that one of the values that is being picked up is in a text field rather than a numeric field.

 

[Kroghr]

Thank you very much. That worked Perfect. I'll make sure i figure the next one out from your example. Thanks again