how to print records/rows selectively?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all,

I am new to access. I've been assigned to work on an accounting database
which contains typical data such entry date, credit amount, debit amount and
the balance.

Now, users would like to have a report which prints credit/debit information
for a given period. HOWEVER, rows for previous months MUST also be included
but not printed. This is done in order to calculate prevoius month(s)
balances, and at the end of the report totals and sub-totals for the year to
date. How can I hide / not print rows which fall outside the date range, but
still keep and use the credit / debit information when calculating totals,
sub-totals, etc....?

Your help is greatly appreciated.
 
You can try use code in the On Format event of a section that cancels the
printing of the section.

Cancel = Me.txtDate < Me.txtSomeOtherDate
 
Thank you for your help Duane. I will try it and if I have problems I will
post the results. In the meantime, what is a section? Are you refering to
areas of the report such as details, header, footer, etc.?
 
Back
Top