Totals don’t display on subform

[Emmanuel]

I have a form which has a subform too.


The form has fields called “Date”, “Particulars” and “amount.” that displays for the subform.

For one reason or the other, when I use the sum, “Total” will be displayed at the buttom of the subform but the sum of all figures in “amount” doesn’t display.

Instead, max, min, average and other functions work perfectly.

I once created a form which I used to display the sum of the amount.
Have created several forms using the same form. But can’t understand why this particular one isn’t working.

Is there something am missing?
Any suggestions will be highly appreciated

[Bob Fitz]

Can you post a copy of the db

[Emmanuel]

W

Can you post a copy of the db

Am kind of not close to my pc now.
Maybe will have to do that when I do

[Emmanuel]

Can someone guide me on how to upload here?

[Welshgasman]

Can someone guide me on how to upload here?

Hit reply or reply with quote, then Go Advanced button, then the Manage Attachments button.

[Micron]

See "How to Attach Files" at the very top of the page.
You might need to use DSum with criteria, not sum.

[Welshgasman]

See "How to Attach Files" at the very top of the page.

Doh !, why didn't I think of that?

[Emmanuel]

W

Am kind of not close to my pc now.
Maybe will have to do that when I do

please find attached copy of the database

[Emmanuel]

Once I search the data using the search button, I want the totals of the data displayed below it in the totals section

[Gicu]

Which form? You don't seem to have a totals section...

[Emmanuel]

Which form? You don't seem to have a totals section...

The forms in the db
There is a totals below it

[Bob Fitz]

They are both "Split" forms. I don't use them.

[Emmanuel]

They are both "Split" forms. I don't use them.

Alright
Noted

[Welshgasman]

Too late for me on 2007 as well.

[Micron]

Had it working for a moment by taking the format off of the table field IMPREST and leaving it on the form control. Stopped working for some reason.
Now I've altered the form so much I'd have to start over, but I did get a sum with a calculated textbox, control source of =DSum("[IMPREST]","[IMPREST]").
Usually I copy a form first, but this time I didn't.