Update Data Source for A Report

[Guest]

Hi All:

I have created a report using data from a query. Now I have set up the
updated data into a new query. Could anyone tell me how can I update the
report using the new query? Thanks.

Charles

 

[fredg]

Hi All:

I have created a report using data from a query. Now I have set up the
updated data into a new query. Could anyone tell me how can I update the
report using the new query? Thanks.

Charles

Open the report in Design View.
Show it's property sheet.
Click on the Data tab.
Set the Record Source property to that of the new query.
Exit.

 

[Guest]

Hi Fredg:

Thanks for your help. But where is property sheet?

Charles

 

[fredg]

Hi Fredg:

Thanks for your help. But where is property sheet?

Charles

Open the Report in Design View.
Click on View + Properties

Or..
Click on the properties tool button.

or...
Click on the little square where the horizontal and vertical rulers
meet. Select properties.