The reports are all in a dropdown list and it would just be more user friendly to have one selection that would generate the report with the data sorted three ways. I'll keep plugging away. Now I'm leaning towards using a UNION query...
Any opinions or suggestions? >Never mind, looks like you HAVE to supply the name of the query.. I >was hoping you could supply a variable that contains the data. >Another option then would be to create a query using your query data >(using QueryNew) but that just seems like too much trouble.. why can't >you have a button for each report sort method? > > > > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3764 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
