[AccessD] Re: another Transform query question

The best way of doing this is to design a form to gather the data.
Then create the SQL Statement based on the form.
Then replace the SQL statement in an existing query for use with reports 
and/or forms for displaying the resulting data.

Robert

At 12:00 PM 2/23/2004 -0600, you wrote:
>Date: Mon, 23 Feb 2004 12:59:13 -0500 (EST)
>From: <Oleg_123 at xuppa.com>
>Subject: RE: [AccessD] another Transform query question
>To: <accessd at databaseadvisors.com>
>Message-ID: <54769.63.251.87.214.1077559153.squirrel at heck.bay9.com>
>Content-Type: text/plain; charset=iso-8859-1
>
>I would hope it would be that simple.. nee, it keeps prompting me for
>status :((
>(not to mention that it takes like 4 minutes for a query to open)
>Also, they change their mind, they now want it to prompt, like I had in
>the first one..
>
>TRANSFORM Count([Ron Data Mid OP].ID) AS Total
>SELECT "Investigation Opened" AS Status
>FROM [Ron Data Mid OP]
>WHERE (((IIf([Ron Data Mid OP]![MS Date Opened]>=[Forms]![Report
>Form]![Start_Date] And [Ron Data Mid OP]![MS Date Opened]<=[Forms]![Report
>Form]![End_Date],"Cases Closed")) Is Not Null))
>GROUP BY [Status]
>PIVOT Format([AMTS Date Opened],"mmm") In
>("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");
>
>
>whats the better way to do prompts ?