OutputTo Snapshot question, batching

[mmohon]

I've got one big report, and basically I want to slice and dice it,
and output it to different snapshot files automatically via a script
so I dont have to babysit it.

I know how to do the OutputTo to get it going to a snapshot file....

The problem is I dont know how to pass the Criteria to the underlying
query the report is based on.

In the Query I do. WHERE [CostCenter] = [Prompt] (prompt being a
arbitrary place I can put in cost center numbers)

How do I do this in VBA (or something like it):

[Prompt] = 4124 OR 3456 OR 5423
OutputTo blah blah snapshot.snp

[Prompt] = 1234
OutputTo blah blah snapshot.snp


basically, I want to 1: set the Criteria...2: Output Report, wash,
rinse, repeat.

Whats the best way I can do that

 

[Alex Dybenko]

Hi,
you can build report recordsource query SQL and then run OutputTo

Prompt="4124, 3456, 5423"

currentdb.querydefs("query1").SQL="Select * from ... " & " WHERE
[CostCenter] IN (" & Prompt & ")"
docmd.outputto ...


--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com