Summing an unbound text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
You magic worked wonders! I could have sworn I did that...but
nonetheless...it worked!

Many thanks!
 
Back
Top