I'm converting a database from Access 2000 into Lotus Approach 97. I'm familiar with Access, but just learning Approach. I've got a calculated field set up on a form with a repeating panel.
What I want the field to do is take each instance of a field called "DRUM_QUANT" on the repeating panel and total it up. Sounds easy enough. So I create a field and place it at the bottom of my form (outside of the repeating panel). I hook it up so it's a calculated type field and set the formula to: SSum(WasteIn.DRUM_QUANT), which should do exactly what I want it to do. Unfortunately, it doesn't. I tried placing the field inside the repeating panel, but no luck. Either way, the field stays completely empty.
I was successful at creating another calculated field which multiplied a unit price by the quantity of drums to get a total price, so I know that I'm going about this the right way. Am I missing something?