Access Reporting

[TimmyK99]

Forgive me if this is hard to understand. I have never coded VBA and only know .net.

I have a report in an access project. What I would like to do is print this report 5 different times using a different query each time. How do I do this? Can it be done in the report? The reason I ask is because I don't have access to the "calling" forms code!

[KGComputers]

HI,

what do you mean on five different times? Is it 5 different formats/layouts?
What do you mean you have no access to the code? Is the code hidden or what?

Greg

[RobDog888]

If you are doing this inside Access VBA then just create 5 where clauses for your reportsource query. Then call the .OpenReport method passing each separate where caluse 5 times each time passing a different clause.