B
bill
What is a good way of displaying data from dynamically created SQL?
The SQL is created based on user selections, so I can't have controls on a
form or report bound to fields in the resultset in advance.
The way I'm doing it now is by creating a view dynamically based on the SQL,
and then using DoCmd.OpenView. The trouble with this approach is I need to
clean up the views periodically.
Thanks
Bill
The SQL is created based on user selections, so I can't have controls on a
form or report bound to fields in the resultset in advance.
The way I'm doing it now is by creating a view dynamically based on the SQL,
and then using DoCmd.OpenView. The trouble with this approach is I need to
clean up the views periodically.
Thanks
Bill