Create a Report from a copy

[iantcook]

I need to create a Report for 2007 data that will give the exact same fields that the 2006 gave. We have the 2006 report created and used it perfectly last year. The Report grabbed data from a query. I wanted to just copy the 2006 Report and change what query it took data from. Can this be done? Thanks.

 

[razorking]

Just right click on the 2006 report and select copy, then past a copy of the report and rename it. Then you can go into design view and change the source to the new query

 

[Dreamweaver]

StrWhere = "[Your Year Control]=" & Format(Date,"YYYY")
DoCmd.OpenReport "YOUR REPORT NAME", acViewPreview, , StrWhere

 

[iantcook]

Thanks, where do I change the source to run the report from the new query?

 

[pbaldy]

I'm curious about your table design. Generally you would only have one report/query, with a date criteria to determine which year's data is returned. You don't have tables for each year, do you?