microsoft access training course - Access reports

Resolved · Low Priority · Version Standard

Mon 26 Nov 2007, 16:44 Delegate Richanjit said...

Richanjit has attended:
Access Introduction course

Access reports

if you want to generate a report in exactly the same format, but want it to point to another query, how do you do that?

Tue 27 Nov 2007, 08:35 Edited on Tue 27 Nov 2007, 08:36 Trainer Pete said...

RE: Access reports

Hi Richanjit, Thanks for the post, this is a great question, but it depends very much on one thing, does the second query have the same fields as the first?
If this is not the case you will have orphan fields in your new report. However if they are compatible then your course of action is to change the Record Source option.
To do this; in the Database window, copy and paste the old report giving it a new name. Open your new (duplicate) report and change to Design view, open the Report Properties sheet, (All tab) and in the Record Source option, click the drop down arrow and choose your new source.
Hope that helps best regards Pete

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.

Access provides an easy method of achieving a running total.

Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

View all Access hints and tips