Independent criteria on report

[Guest_imported]

I am a newbie and have built a basic DB for a non-profit for use on our fund drive. I would like to have two fields on a sales and collections report based on a date Parameter Query, one field listing and totaling invoices for pledges made during a given date range and another field listing invoices for pledges paid during the same date range. The problem I have run into is that I don’t want the criteria for one field (pledged during given date range)to effect the data returned in the other (pledges paid during date range). I don’t want pledges made and paid, or pledges made or paid. I need the data criteria to be independent of the other. Any suggestions?

 

[randysmid]

Hi,
I do have an idea, but you may need to make changes to your table layout. It seems the problem in the two different reports is knowing which pledges have been paid, and which have not yet been paid. Is this correct?

First, each pledge should have two numeric fields, one to represent the amount of the pledge, and the other to show the amount received.
Second, in a query, the amount received can have a criteria that selects only those pledges where it is equal to 0 (zero), or not equal to 0, e.g., criteria for amount received would show &quot;=0&quot; or &quot;<>0&quot; (without the quote marks, since these are numeric fields).

HTH,
Randy Smith
California Teachers Association

Here is the technique I would use: