Re-using a Report

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
 
D

DevalilaJohn

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")
 
Top