Sending output To

[mission2java_78]

Why cant I use the where clause when sending output to a file. For reports that is...I noticed I can do...

DoCmd.OpenReport rptName, acViewNormal,,"Blah=" & BlahID

But I cant do:

DoCmd.OutputTo with the where clause??

Surely there must be a way to where this sucker out.

Jon

 

[bradcccs]

I have found the same for TransferText also.

The only option I discovered, is to effect the "where" action with the "criteria" statement of an underlying query.

Obviously not as versatile as the Where clause itself, but certainly enables you to output only the required data etc.

Brad.

 

[mission2java_78]

I cannot change the underlying query for this report...
does anyone else have a solution?

I want to use DoCmd.OutputTo but using a WHERE clause for a report...

Jon