M
Michael Clifford
I need to design an application that allows users to select an existing
field by pushing a button on a form. The routine will calculate the percent
null. That's all working well.
However, the end users now want an exception report that will give details
about records that are null. This is launched by pressing a corresponding
button.
One of the goals is to limit the number of persistent objects (reports,
queries). A temporary CreateQueryDef is being used.
The problem: How can a serviceable exceptions report be created from the
querydef? I've spent hours in the Internet and the consensus seems to be to
use Excel and transfer the data. Surely there's got to be a way to create an
instant report from a querydef and stay within Access 2000. Please advise.
Thanks in advance.
Regards,
MJC
field by pushing a button on a form. The routine will calculate the percent
null. That's all working well.
However, the end users now want an exception report that will give details
about records that are null. This is launched by pressing a corresponding
button.
One of the goals is to limit the number of persistent objects (reports,
queries). A temporary CreateQueryDef is being used.
The problem: How can a serviceable exceptions report be created from the
querydef? I've spent hours in the Internet and the consensus seems to be to
use Excel and transfer the data. Surely there's got to be a way to create an
instant report from a querydef and stay within Access 2000. Please advise.
Thanks in advance.
Regards,
MJC