Skip filing reports w/o data? (1 Viewer)

[Gunnerp245]

I have a macro that files a particular set of reports; It works properly. Some of the reports occassionally will not have any data, depending on the data being analyzed.

I would like to NOT file the reports without data. How would I go about it?

Thanks,
Gunner...

 

[Smart]

I would do a dlookup on each query that rteh reporst are based on prior to calling the report.
If the result from the dlookup is null don't call the report

Dim ans1 as string

ans1 = nz(dlookup("Columnname","yourquery"),"")

if ans1 <> "" then
Run the report
end if

 

[Gunnerp245]

Smart,
Appreciate the response. Where and how would I call the vba code you posted?
Gunner...

 

[KeithG]

In the condition column of the macro

 

[Smart]

As Keith g says