Re-using a Report

  • Thread starter Thread starter Steven Sutton
  • Start date Start date
S

Steven Sutton

I have a report based on a particular Query. I want to
copy the existing Query, make a change to it (I am adding
another parameter entry point) and rename it. Then I would
like to duplicate the original Report and base the
duplicate on the new Query instead of the original.
Unfortunately, the duplicated Report still looks to the
original Query. Is there a way to keep the layout of a
report but change which query it uses?

And on a side issue, can you (I assume Yes but I can't
find the appropriate command) convert a Date value to a
Text string?

Thanks
 
For your first question, change the Record Source under Data in the
properties box. For the second use the format function e.g
Format([dateField],"mm/dd/yy")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing a report with a chart 15
Report Query Works 2nd Time, But Not 1st 14
report using a subreport based on a crosstab query 5
Problem opening report 1
Access Access Report Works on One Machine but not Another 3
Filter within a report 4
How to copy aQuery to a new Table? 3
Report has more records than source data 1

Back
Top