Using the COUNT function on a sub form which is based on a query

[DylanSAT]

Hi,

Doing a school project and need to add a count function to a sub form that is based on my query. The count function just needs to be displayed on the bottom of the sub form showing how many records are in the sub form.
When I do this, the function works all good.
When I add the function to a header or footer, so that it doesn't show a column and repeat itself each time.

I have tried and tried and tried again with this and I am pretty desperate now. Any help would be greatly appreciated.

 

[Misiek]

why don't you post your function here?

my one works, no matter if I place it in footer or elsewhere:

=DCount("NameOfFieldYouWantToCount","NameOfQuery")

or one with criteria 

=DCount("fieldName","QueryName","AnotherField=True AND OtherField=[Forms]![FormName]![cboFieldName]")

 

[DylanSAT]

At the time I didn't have the forumla.
Will respond with it.