Skipping page conditionally

  • Thread starter Thread starter Marianne
  • Start date Start date
M

Marianne

I have created a report, with one record plus a lot of calculated data
per page. Some of the raw data for the calculations exists in related
tables. If that raw data isn't present, I want to skip the page
completely.

I tried a record source SQL statement with an INNER JOIN to test the
existence of the related data, but that didn't work. Access doesn't
seem to like records from a joined table as a record source. I tried
setting Cancel to True in a PageHeaderSection_Print event procedure.
That canceled the whole report, not just the page. I thought about
using a filter, but it would reference the wrong table.

(By the way, where can one find the definition of the parameters to
the PageHeaderSection event procedures? I can find very little
information on this.)

Marianne
 
Hi Marianne,

You were heading in the right direction, if I understand it correctly.
Weed out those records without any raw data in the report's record source
query. You can do it something like this:

select MainKeyField, Field1, Field2, ..., Fieldn
from MainTable
where exists
(select *
from RawDataTable
where RawDataTable.MainKeyField = MainTable.MainKeyField);

You will of course have to adapt that to your actual table and field
names.

Clifford Bass
 
Hi Marianne,

You are welcome! Glad to have been able to expand your horizons.

Clifford Bass
 
Back
Top