Counting

  • Thread starter Thread starter SPB
  • Start date Start date
S

SPB

I am trying to get a count in a Report footer. I have
tried all that I can think of. The data is in a Date
Header as need to hide any duplicate dates.
Any Help, Thanks
 
SPB said:
I am trying to get a count in a Report footer. I have
tried all that I can think of. The data is in a Date
Header as need to hide any duplicate dates.
Click to expand...


Add a new, invisible text box named txtCounter to the group
header. Set its expression to =1 and its RunningSum
property to Over All.

Then the report footer text box can display the number of
different group values by using the expression =txtCounter
 
-----Original Message-----



Add a new, invisible text box named txtCounter to the group
header. Set its expression to =1 and its RunningSum
property to Over All.

Then the report footer text box can display the number of
different group values by using the expression =txtCounter
Click to expand...
Thanks for the quick reply, did as suggested without sucess

The result is 1, the running total on the group is 31
any other suggestions

Thanks
 
-----Original Message-----
=txtCounter
Click to expand...
Thanks for the quick reply, did as suggested without sucess

The result is 1, the running total on the group is 31
any other suggestions
Click to expand...

Maybe I misunderstood your question and/or report
arrangement. Could you post back with a sample of your
report's appearance with an explanation of what you're
getting and what you want to get?
 
-----Original Message-----


Maybe I misunderstood your question and/or report
arrangement. Could you post back with a sample of your
report's appearance with an explanation of what you're
getting and what you want to get?
Click to expand...
I am using a Date header to group data by each day. Each
day has a type identified and I am trying to total / count
different type of days in the footer. The unbound
expression in the header gives the correct count, it just
not working in the Report footer

Sorry about the other post. did not know!

Thanks
 
-----Original Message-----
I am using a Date header to group data by each day. Each
day has a type identified and I am trying to total / count
different type of days in the footer. The unbound
expression in the header gives the correct count, it just
not working in the Report footer
Click to expand...

I'm still confused. Are you sure you have the total count
text box in the Report footer and not in the page footer?
 
-----Original Message-----


I'm still confused. Are you sure you have the total count
text box in the Report footer and not in the page footer?
Click to expand...
Report layout as follows;
Report Header - Titles only
Date Header - Sorted by date (day) Details from Query
Details - Blank
Report Footer - Totals of date header (not working)?

The body of the report (Date Header) is created perfectly
including the =txtcounter expression to =1 and its
RunningSum Property to Over All, just the report footer
does not give the total for txtcounter

Help
 
SPB said:
Report layout as follows;
Report Header - Titles only
Date Header - Sorted by date (day) Details from Query
Details - Blank
Report Footer - Totals of date header (not working)?

The body of the report (Date Header) is created perfectly
including the =txtcounter expression to =1 and its
RunningSum Property to Over All, just the report footer
does not give the total for txtcounter
Click to expand...


That's a new one on me. I've never seen a problem with
this. Are you sure you're using the report footer and not
the Page footer?

Please post back with the exact name and expression for the
two text boxes.
 
Marshall

I think I found the problem, can you suggest a solution
The count/sum works when I take out the date limitation
from the query, whats the workaround. I need to create a
report based on a month.

Thanks
 
Marshall

I think I found the problem, can you suggest a solution
The count/sum works when I take out the date limitation
from the query, whats the workaround. I need to create a
report based on a month.
Click to expand...


This is getting weirder and weirder. I can't imagine how
the query's Where clause could affect a running sum. I'm
fairly certain that the problem must be somewhere else.
--
Marsh
MVP [MS Access]



 
Back
Top