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
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