New User Question

Topic

New Reply

I have created a simple database to track requested changes to a set of internal applications. All requests–past, present, and future–are stored in a table. I have a query that picks off changes for the current quarter and a report that displays the status of current programming changes.

Near the end of every quarter, we have users acceptance testing the current changes while we’re planning for the next quarter. In an attempt to facilitate this process, I made a copy of my query and adjusted the implementation quarter for the planning phase.

The next logical step was to make a copy of the report, and revise it so it references my new query rather than the old query. Unfortunately, I couldn’t figure out how to do this. Can anyone help? I’m new to Access, so be gentle.

Also, why is it that my table and queries open instantaneously, but it takes about 20 seconds to open my report, even in design mode? Did I set up something wrong?

Thanks,
Bob

Reply | Quote

Replies

One way to do this is to open your report in the design view. On the Menu Bar, click File/Save As and give the report a new name. Then click the Properties button on the Toolbar. This will open a properties window for the report. Click on the Data tab and change the Record Source to the name of your new query. This will create a new report with the new query as it’s source.

I’m not sure how to answer your second question … someone else may know all the reasons for the slow open.

Reply | Quote

I’m not sure that you need a new query and a new report. Why not just put a selection criteria in your query, to select for the quarter you want? Then you only need 1 query and 1 report.

As for the time to open your report, it could be a number of things. First of all, are you using a split database design in which you have a backend containing your tables and a frontend containing everything else? Are you working over a network? Have you compacted your database recently? Does your report have any embedded graphics? etc.

Reply | Quote