ACCESS USE VBA TO MODIFY A CROSSTAB QUERY

摘要

Our menu form contains buttons for both detail and summary reports. These reports are based on the qSales-Crosstab query, which summarizes data to the last day of each month and, therefore, doesn't include individual dates. To implement date criteria that the user inputs on the menu form, criteria need to be in the query that creates the crosstab. We will use VBA to construct the Where clause (to limit records in the query) and then modify the SQL statement that defines the query. Create a copy of the qSalesCrosstab query and name it "qSalesCrosstab -Orig." Each time a report button is clicked, this query will be used to create the qSalesCrosstab query.