Generate SQL String through form values
I am in the process of making a reports form for my client where they will be able to generate a query on the fly as it were.
I have three radio buttons, All, Active and Inactive. So all will show both the active and inactive user accounts, active will only show those who's active status is set to true (yes/no field in the table Users) and inactive will show all those whos status is false.
There are also another set of radio buttons which determine different criteria of the report. Is there a way for the form to generate a SQL string based on the fields and radio button values and then open the report using that string as a filter?
Any hints tips or ideas would be cool
Thanks
Bob
I am in the process of making a reports form for my client where they will be able to generate a query on the fly as it were.
I have three radio buttons, All, Active and Inactive. So all will show both the active and inactive user accounts, active will only show those who's active status is set to true (yes/no field in the table Users) and inactive will show all those whos status is false.
There are also another set of radio buttons which determine different criteria of the report. Is there a way for the form to generate a SQL string based on the fields and radio button values and then open the report using that string as a filter?
Any hints tips or ideas would be cool
Thanks
Bob
Last edited:
