L
Lorien2733
I have an insurance report that prints my starting totals, any changes made
for that month and then final totals for each agency. The report is based on
a make-table query that selects records with changes and tacks on the
starting totals from another table. The problem is that if there haven't been
any changes that month for a particular agency, the make-table query table is
empty and the report doesn't work. I still want to print out the starting
balances and then carry them down to the final totals. How can I get the
starting totals from the other table into the report when there are no
changes? The on no data event? DLookup? Is my make-table approach wrong from
the beginning? I'm having a brain freeze. Any suggestions?
for that month and then final totals for each agency. The report is based on
a make-table query that selects records with changes and tacks on the
starting totals from another table. The problem is that if there haven't been
any changes that month for a particular agency, the make-table query table is
empty and the report doesn't work. I still want to print out the starting
balances and then carry them down to the final totals. How can I get the
starting totals from the other table into the report when there are no
changes? The on no data event? DLookup? Is my make-table approach wrong from
the beginning? I'm having a brain freeze. Any suggestions?