Kevin
Mon Apr 25 07:15:42 CDT 2005
Hi BDill,
A custom query is a SQL Statement. If you are selecting records, use SELECT
columna, columnb... FROM tableName WHERE [Module] = 'Pricing'
Note that you will have to fill in the column names and so on. The ellipse
is not part of the query.
--
HTH,
Kevin Spencer
Microsoft MVP
.Net Developer
What You Seek Is What You Get.
"BDill" <BDill@discussions.microsoft.com> wrote in message
news:1FD3CB5D-664C-4BCC-9BB7-2E4A4FCB9F8B@microsoft.com...
> That's just it, I am not writing an actual query. I am using the FP
> Wizard.
> There is an option to either use a record source or custom query. I have
> always used the record source. I don't know how to use the custom query.
> My
> guess for the query is If [Module] = Pricing then include the record in
> the
> database results.
>
> Thanks
>
> "Kathleen Anderson [MVP - FrontPage]" wrote:
>
>> Post the SQL from your custom query please.
>>
>> --
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> web:
http://www.spiderwebwoman.com/resources/
>> blog:
http://msmvps.com/spiderwebwoman/category/321.aspx
>>
>>
>>
>> "BDill" <BDill@discussions.microsoft.com> wrote in message
>> news:B113A191-29CA-40D6-9812-716F37C36973@microsoft.com...
>> >I am not an expert but have used the query wizard alot. I have a field
>> >in
>> >a
>> > database. The filed name is "Module". It is a text field. I am using
>> > the
>> > wizard to find only records where "Module" = "Pricing". I have
>> > selected
>> > the
>> > fields to be displayed, set the criteria to Modual equals Module and
>> > set
>> > the
>> > default of Module to "Pricing". The database is there and it should be
>> > found. I then decided to write a custom query. I found where to do it
>> > but
>> > my structure is wrong.
>> >
>> > Thanks anyone for the help!
>>
>>
>>