Print a report that contains no data

[baarrnnee]

I have a database that I use to record weekly donations from church members. When I go to print Tax Receipts, the report gathers the information from the database and prints the page as requested. The problem is if there were no donations, then the report does not print and is omitted. I would like to be able to print a zero donation report for those who did not donate in during the year.

Thank you,
Karl

[ranman256]

you can create Q1 that pulls your normal data,
then Q2 that gives every account a zero.

then make Q3 a UNION QUERY to combine both so everyone has a value:
select * from Q1
union

select * from Q2

then make Q4 to sum values in Q3 and everyone has a value. Bind this qry to the report.

OR -------
make Q1 (the only query needed) an outer join to get all values , even NULLs if they had no data.
then you get all customers but the values will be blank if they had no data.

[Micron]

Why not just set one or more donation fields to default to zero (assuming those fields are number type fields)? It won't fix your current data but will prevent the issue from then on. To 'fix' the current records, you'd run an update query to alter all Null donation records to zeros. Good data is always better than band aid fixes IMO.

[June7]

Micron, so create a record every week for 0 donation for members that do not make donation?

Build a query that summarizes donations then join that query to members table. Use that query as source for report.

[Micron]

Micron, so create a record every week for 0 donation for members that do not make donation?

Whoops, no, certainly not. I guess I focused on the year part:

I would like to be able to print a zero donation report for those who did not donate in during the year.