Change the HAVING Clause on the fly for a report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wes Brooks - 27 Sep 2006 20:52 GMT

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

Reply to this Message

Alex Dybenko - 28 Sep 2006 06:56 GMT

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

Signature

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

> Hello expert,
>
[quoted text clipped - 12 lines]
>
> Thanks, Wes

Reply to this Message