Report and queries

[azgambit]

Report and queries, aaarrrrggggg

I am currently working on a database to assist with the reporting of various incidents. Since all incidents tend to be different, I have had to create numerous different tables, some or all of which may be used to report a single incident.

Anyway, my problems start to crop up when trying to generate the report. And most of us know, there always has to be a report <grin>. I am looking for a query/expression/whatever that will search all the tables for records matching a certain criteria that will be entered. Then, take only those records that match the criteria and shove them into a report.

The problem I get is that regardless of whether a table has a record matching the criteria or not, the report has headers for the information. If there is not record mtaching the criteria, I don't want to see headers with blank spaces.

Does this make sense?

Any suggestions?

P.S. I am somewhat of a noob here, so you may need to use small words

Thanks everyone!!!!!!!!

 

[llkhoutx]

Use the report's OnFormat event to hide/alter your headings based on criteria, presumably indicated on a visible or hidden for.

 

[azgambit]

Any suggestions on how that would be scripted? Or how to set up the parameters for the criteria?

Like I said, not very good when it comes to this. Still learning.

Thanks!!!!!!!!!!