Frontpage Query

[BDill]

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!

 

[Kathleen Anderson [MVP - FrontPage]]

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]

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

 

[Kevin Spencer]

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.

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

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