Search results

Thanks for the info guys. I would use the sql statement except I need counts of each of the fields I am displaying on the report. I use a query for each combo box to get the count and create a table to store the values in. I am looking into the querydef now, but I am not sure if it will work the...

I have a form with three combo boxes and am looking to open a report based on the choices they make. After each combo box is selected a query is run that makes a table based on their choice. I want to be able to use the appropriate table, without having to set it each time. The data displayed is...