Print two reports?

[option]

Hey all,

I have two reports that need printing, one showing the full record ID, the other showing the first 5 digits. I'm basing the reports off of the same query, and what I would like to do is something like the following pseudo-code:

do until rst.eof
   Print report A for record 1
   Print report B for record 1
rst.movenext
Loop

Is that a possibility, or am I stuck printing Report A for all records, then Report B for all records? I'm trying to prevent the user from manually having to sort the printed reports, but it doesn't seem like it'd be much of an easy task to print in this manor.

Any ideas?

 

[pbaldy]

You should be able to do that. I'd use this technique to print the filtered report, using the appropriate value from the recordset:

http://www.baldyweb.com/wherecondition.htm

 

[option]

That's exactly what I needed! Thanks a million!

 

[pbaldy]

No problem, glad it helped.