Get the query working in Access, then save it using some
name in Access.
Then, add the .mdb file to a fpdb folder in your
FrontPage Web site, open a new page, and choose Insert,
Database, Results.
In the first page of the wizard, specify your .mdb file.
In the second page, specify your saved query name.
From there, set any options you want.
Be sure to save the page with an .asp filename extension
and to test it by browsing with an http:// URL.
Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
-----Original Message-----
Hello, I am trying to display the results from my
database query. I have 5 columns in my query and I want
to be able to display the results from each one
seperately on the page. I am not sure how to connent to a
query as I have never done it I am assuming it uses
something like "Select * FROM pollresults" but I do not
know how to go beyond selecting the table because I
really have very little knowledge of asp, only what I
have learned by manipulating others codes. each column
would have a name like sumofStaci, sumofMelissa. Since
these results are from one of my polls. Thanks for any
help, Jim
