Summing an unbound text box

[Guest]

Hi there,

On my report I have three fields: district, submission date and province. I
have it grouped by province and district. THe detail section contains on the
submission dates for a particular month.

I want to have the district, and a count of the number of submissions (for
the designated month).

I added an unbound textbox, called txtCountSubmission. The control source
is =count(submissiondate). This gives me a count of all submission dates by
district....great!

Problem:

I want to now sum all district counts so that I can have a grand total of
how many submissions, not just a break down by district. how can I do this?

I tried creating this in the query, but I need the submission date so that I
can filter my report for current month submissions and previous month
submissions. Subsequently, the group function doesn't work. How can i get
around this?

Many thanks in advance.

 

[Terry]

Carlee,

Add a report footer to your report (found under View in
design mode). Copy your control "txtCountSubmission" into
the report footer and it should provide a count for the
whole report.

HTH,

Terry

 

[Guest]

You magic worked wonders! I could have sworn I did that...but
nonetheless...it worked!

Many thanks!