How To Copy A Report

[NYFashionToGo]

I could use a little advice on something I am trying to achieve.

I have one report set up for Printing Sales Receipts and another for Invoices... I basically want to duplicate both of them. Having the criteria in the quewry being different..

Due to the nature of the way that I am forced to print shipping labels through XML Endicia. It causes My sales receipts to be out of sequence with my shipping labels.... It gives me little extra work manually getting things in order. I tried sorting several columns. But it does not work because of the 6 services I offer for shipping...

I already copied the query that gets the report and have the criteria of one Being ="United States" and the second being <>"United States".
I would like to make a simple transition to my sales receipts (report) Then my Invoices to reflect the same change. So I can basically run the report twice One from each query. I need to change the field list cleanly.. I just do not want to mess up my database... Any advice would be appreciated.. On how to copy the report and change the field list based on another query.
Thanks

 

[dhookom]

If the reports are the same, you shouldn't copy it. You can change the records in the existing report record source or even change the Record Source property.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[NYFashionToGo]

Okay I see what You are talking about, what I do not understand is how to change it back and forth. I would need to run it twice. to first print USA then International. I understand how to make the changes, But to automate both. so they both run on one click.....

Thanks for your input..

 

[dhookom]

You stated "change the field list cleanly". Do you really change the field list in the report's record source or are you only changing the criteria? If you are only chnaging which records are returned then there are tons of solutions posted on the web. My preferred method is to use the Where Condition of DoCmd.OpenReport.

DoCmd.OpenReport "rpt...", acPrint, , "[Country]='United States'"
DoCmd.OpenReport "rpt...", acPrint, , "[Country]<>'United States'"

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[NYFashionToGo]

Okay Great!, Thanks I understand now. Thanks for your help I appreciate it....