[AccessD] Re: Automating parameterized action queries.....

Rocky,

It is the right solution if you take it a step further.

2 queries  MyQuery_0 and MyQuery_1

_0 has the straight SQL without a WHERE clause

Open it, get the SQL, build the WHERE clause and append the 2 statements 
together.

Replace the SQL statement in _1

Reports and such are based on _1

Robert

At 12:00 PM 3/8/2005 -0600, you wrote:
>Date: Tue, 8 Mar 2005 08:40:45 -0800
>From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
>Subject: Re: [AccessD] Automating parameterized action queries.....
>To: "Access Developers discussion and problem solving"
>         <accessd at databaseadvisors.com>
>Message-ID: <00b701c523fd$93d86e60$6b01a8c0 at HAL9002>
>Content-Type: text/plain; format=flowed; charset="iso-8859-1";
>         reply-type=original
>
>John:
>
>All true.  But where I have a lot of parameter values - like the data
>selection criteria in the manufacturing system, I actually build the SQL
>statement or report filter in code and push it into the record source or
>filter of the report instead of using a stored query. Another brute force
>solution. :)
>
>Rocky