Hi,
I have a database for membership to a group that I belong to and I need to
create a report that will just show the total members, total members paid and
total members unpaid. I have a query of members and also queries for the
paid and unpaid members. But try as I might I can't seem to create a simple
report that will just give the totals I need.
I know this is going to be so easy for some of you!
Hi
Just create the report you want without the totals. Then when you
have all the "bits" in the report that want then create the totals
your looking for.
You can add totals or other calculated results in quite a few places
and it in th area of the report that the calculation is in that will
dictate what is included.
As an example if you have a sorted field with a group footer if you
have a group footer most calculations will reflec only the records in
that groups.
So to get an overall result - ensure you can see the report footer and
create a few unbound text boxes. In the properties box / row source
add some thing like this
=Sum(Nz[FieldName],0)
This will give you the total sum of a number field. The Nz function
gives an amount o zero to any fields that are null
You can "filter" the summing like this
=IIf(Sum([FieldName]="Not Paid"),[TheyOwe])
This would some sum the field TheyOwe if FieldName contaned the text
Not Paid.
etc, etc
There are zillions of combinations it's simply a matter of working out
what you want to do.
Don't forget in reports it's sometimes a good idea to include the
results in text
Like this
=IIf([MemberPhone] Is Not Null,"This member's phone number is " &
[MemberPhone],"This member does not have a phone number recorded.")
As I said there are zillions of combinations.
Good luck with your project
Wayne
Manchester, England
