A
Anne
I inherited a database to which I need to make an adjustment. The database is
designed to (giving a very high overview here), based on a query housed in a
form’s command button, run a macro that imports, based on the date range
entered on the form, report data from the company’s LAN.
The output query results include a detail table of the records within the
input date range and a summary total table of the records by group. Instead
of displaying the two output tables, I want to instead, run the query, and
once the query completes, not have the resulting tables display, but instead
be able to generate reports by group.
I have figured how to do this by creating a report based on the detail query
using FindPOLICY (column for group numbers), but I want the user to be able
to be able run the query and generate the reports all from the form.
designed to (giving a very high overview here), based on a query housed in a
form’s command button, run a macro that imports, based on the date range
entered on the form, report data from the company’s LAN.
The output query results include a detail table of the records within the
input date range and a summary total table of the records by group. Instead
of displaying the two output tables, I want to instead, run the query, and
once the query completes, not have the resulting tables display, but instead
be able to generate reports by group.
I have figured how to do this by creating a report based on the detail query
using FindPOLICY (column for group numbers), but I want the user to be able
to be able run the query and generate the reports all from the form.