T
Tim
All,
I am trying to create a report that will display a sum based on
multiple criteria.
I have a query listing gifts and the appeal and date associated with
the gift. The appeals are named relatively the same except they have a
year at the end of the name.
I want a listing like this:
99/00 00/01
Christmas Appeal sum sum
A crosstab query gets me close. I can't figure out how to get it to
display by fiscal year (April-March) instead of calendar year (Jan-
Dec).
If I had that I could simply sum(iif(left("mNLC",1),Amount,0))
hopefully and be done with it.
Does anyone have any hints or suggestions?
I am trying to create a report that will display a sum based on
multiple criteria.
I have a query listing gifts and the appeal and date associated with
the gift. The appeals are named relatively the same except they have a
year at the end of the name.
I want a listing like this:
99/00 00/01
Christmas Appeal sum sum
A crosstab query gets me close. I can't figure out how to get it to
display by fiscal year (April-March) instead of calendar year (Jan-
Dec).
If I had that I could simply sum(iif(left("mNLC",1),Amount,0))
hopefully and be done with it.
Does anyone have any hints or suggestions?