Change the HAVING Clause on the fly for a report

[Guest]

Hello expert,

I have tried and tried but I couldn't make it work.

The report can be called by the form with the where clause criteria. But it
seems not working for the HAVING clause.

Now I have a query that I need to pass in the parameter values for some of
the fields on the fly. What is the best approach to modify the parameters on
the query? I'm using Access 2003.

Also how to pass parameter values to UNION query?

Thanks, Wes

 

[Alex Dybenko]

Hi,
I think best approach - if you build a query SQL in a code before running
report, like:

currentdb.querydefs("MyQuery").SQL="Select " & fieldlist & " From " ....

and then use this query as report's recordsource

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