SubTotals from subform

[Luther1978]

I have a subform based on a query. On this subfrom there is a column that contains a string which can be one of 3 values.

"In Time", "Overdue" or "Pending"

On my Parent Form, I have a text box that I want to display the amount of Entries that are "Overdue", and a text box to display the amount that are "In Time". How can I do this?

Many thanks in advance

Martin

 

[Orion45]

I have a setup in my current project that work this way. My subform is a continuous form with a hidden field in the footer that sums an amount field in the detail section above. The field has a control soure of =Sum([PaymentAmount]) A field in the footer of the main form then references this field with a control source of =CLng(Payment_subform.Form!total). If you are also trying to sort out three different totals you may have to add an iif statement to the total field's control souce on the subform. Hope this helps.

 

[Luther1978]

Thanks Orion, unfortunately this wasn't what I waws hoping for. I've already succeeded in achieving a total field although I was dissapointed in how messy the procedure to do so was in Access. What I want to do is to Count the number of times I have the "In Time" string in one of the columsn within my subform, perhaps subtotal was the wrong use of words.

Many thanks
Martin