Filtering a Report for Printing

[mcambrose]

I have a report that has a jpg filter file for each record. I can't print the
entire report at once because it crashes when it opens up almost 100 jpg
files. I tried to use docmd.openreport using the wherecondition to open the
report using a filter. I then printed the report using DoCmd.PrintOut
acPrintAll. I was thinking that opening the filtered report with the
wherecondition would cause only the pages from the filtered report to be
printed even though I used the acprintall. I am able to print this report in
three phases using three different querries, but I wanted to do it using only
one query. Any suggestions are appreciated.

 

[mcambrose]

THanks Alex. I have tried that method before and had some trouble because I
am not proficient in writing queries. However, I will go back and try it
again, since you think this is the best thing to do.