G
Guest
I would like to create a user defined query, where the USER gets to choose
specific criteria on which they wish to query. This means that the user can
select to query between table 1 and table 2, and select field 1 from table 1
and field 3 from table 2 and run a query. The query would be general enough
to take in the variables selected by the user and output the results.
I've thought of using a form and some combo boxes to select the tables and
fields they want and having a query read the values as a variable. However
SQL does not like the idea of using a variable to replace the table name and
field names. Any ideas??? Thanks!
specific criteria on which they wish to query. This means that the user can
select to query between table 1 and table 2, and select field 1 from table 1
and field 3 from table 2 and run a query. The query would be general enough
to take in the variables selected by the user and output the results.
I've thought of using a form and some combo boxes to select the tables and
fields they want and having a query read the values as a variable. However
SQL does not like the idea of using a variable to replace the table name and
field names. Any ideas??? Thanks!