Afternoon all!
I'm trying to use the COUNT function to display the number of records in a group footer on a report where values in one of the fields = 1. In short, does anyone know how to specify criteria in a group footer using COUNT?
I've looked briefly at using DCOUNT, but this gave a result from the source table, rather than from the group that I need to show the result for....
Cheers.
Chris.
I'm trying to use the COUNT function to display the number of records in a group footer on a report where values in one of the fields = 1. In short, does anyone know how to specify criteria in a group footer using COUNT?
I've looked briefly at using DCOUNT, but this gave a result from the source table, rather than from the group that I need to show the result for....
Cheers.
Chris.