Plant A Tree
07-25-2000, 06:00 PM
In reporting monthly events for our nonprofit I want Access to merely count the # of events & used the expression as follows:
"=Count([Event ID])". The total comes out wrong, I think because in the detail section of the form, which allows for multiple entries, each item listed for that event is connected to the same event ID#, falsely inflating the ID count. Is there a way for the program to recognize & count only uniquely different ID's? Using the date field does not work since many events can occur on the same date. Any ideas, please?
I tried Pat Hartman's idea, but it didn't work. More information: In the structure of the report I used a Report header & footer, a Page header & footer (for page# & date), a Date header & footer (set to group on 'month'), an Event ID header (for things listed only once such as # of volunteers, # of project support people & their value), a Detail section for the multiple items in each event (# of trees of each size & type & their value). An Event ID footer contains the Total Project Value calculation that Pat Hartman helped clear up in the other topic question - thanks a million, Pat! The Count function expression I'm struggling with is placed in both the Date footer to count events of a single month and in the Report footer to count events year-to-date. The result of both is the same - it falsely counts the ID#'s attached to each item listed in the Detail section instead of counting only uniquely different ID's. (The attachment of ID# to each type & size of tree shows up only at the Table or Query levels. Is there a way to suppress the counting of those?) 'Hiding duplicates' in Event ID properties doesn't help. The only Table that shows a single listing of events is 'Tree Events', so I tried to make the report go to & count the 'Event ID' field in that table as follows:
=Count([Forms]![TreeEvents Entry Form]![Event ID]) This won't open - wrong formula.
=Count([TreeEvents]![Event ID]) This opens but counts the false count - too many! Any ideas??
[This message has been edited by Plant A Tree (edited 08-03-2000).]
"=Count([Event ID])". The total comes out wrong, I think because in the detail section of the form, which allows for multiple entries, each item listed for that event is connected to the same event ID#, falsely inflating the ID count. Is there a way for the program to recognize & count only uniquely different ID's? Using the date field does not work since many events can occur on the same date. Any ideas, please?
I tried Pat Hartman's idea, but it didn't work. More information: In the structure of the report I used a Report header & footer, a Page header & footer (for page# & date), a Date header & footer (set to group on 'month'), an Event ID header (for things listed only once such as # of volunteers, # of project support people & their value), a Detail section for the multiple items in each event (# of trees of each size & type & their value). An Event ID footer contains the Total Project Value calculation that Pat Hartman helped clear up in the other topic question - thanks a million, Pat! The Count function expression I'm struggling with is placed in both the Date footer to count events of a single month and in the Report footer to count events year-to-date. The result of both is the same - it falsely counts the ID#'s attached to each item listed in the Detail section instead of counting only uniquely different ID's. (The attachment of ID# to each type & size of tree shows up only at the Table or Query levels. Is there a way to suppress the counting of those?) 'Hiding duplicates' in Event ID properties doesn't help. The only Table that shows a single listing of events is 'Tree Events', so I tried to make the report go to & count the 'Event ID' field in that table as follows:
=Count([Forms]![TreeEvents Entry Form]![Event ID]) This won't open - wrong formula.
=Count([TreeEvents]![Event ID]) This opens but counts the false count - too many! Any ideas??
[This message has been edited by Plant A Tree (edited 08-03-2000).]