Query Columns instead of Records

[Rob]

Hello, I work with frontPage on a daily basis for our
website at www.Blue-White.com . I am currently working
with versions 2002 and 2003 (Beta).
I am not a programmer, but I am pretty good with tweaking
the code FrontPage generates and adding simple JavaScript.
I can run plenty of great queries for records in a DB. How
do I run a query for Columns in a table and display all of
the records that match the columns in the SQL statement. I
only want to show the Columns that are asked asked for.
All I need is a SQL statement example for this. I'll use
this in the DB Results wizard. I am using MS Access 2002.
Thanks for the help! Rob
P.S. FrontPage 2003 Beta is AWESOME with the script
editing and the Split view of code and browser.

 

[Kathleen Anderson [MVP - FP]]

Hi Rob:
The Database Results Wizard will build the SQL statement for you. Step 3 will let you choose what fields get displayed and also lets you define search criteria. When you finish the wizard, your SQL statement can be found in HTML view.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/