J
Joel
I can't seem to find a good way to do this correctly.
For each Structure that is in the database has an Inspection Criteria. There
can be several different criteria for each Structure (Stairways,Working
Sufaces, Ect..).
In the form for each Structure I have checkboxes for each Criteria and they
are stored in a different field for each type in the table.
The problem comes when I do a report and need to sort by the Inspection
Criteria (EX. Need all Stairways and Walls).
What would be an easy way for users to select what criteria they want on the
report? (I have a form that comes up when you open the report that have all
the different Criteria checkboxes to select from. The problem is that I would
have to do a TON of code writing to re-write the SQL statment for each
posible combination of different Critera. It comes out to be ~160 different
SQL statements!)
Any ideas / suggestions would be greatly appercated!
Thanks
For each Structure that is in the database has an Inspection Criteria. There
can be several different criteria for each Structure (Stairways,Working
Sufaces, Ect..).
In the form for each Structure I have checkboxes for each Criteria and they
are stored in a different field for each type in the table.
The problem comes when I do a report and need to sort by the Inspection
Criteria (EX. Need all Stairways and Walls).
What would be an easy way for users to select what criteria they want on the
report? (I have a form that comes up when you open the report that have all
the different Criteria checkboxes to select from. The problem is that I would
have to do a TON of code writing to re-write the SQL statment for each
posible combination of different Critera. It comes out to be ~160 different
SQL statements!)
Any ideas / suggestions would be greatly appercated!
Thanks