Thanks. That was a little helpful, but now I am trying to create the html
template I found sample code from office, but was wondering if I can be more
specific in the look. Here is the code I got from Microsoft and here is what
I want to do:
I want it to all be on one page (can I do this)
can I use the query and import the data into an html template and set it up
the way I want it (i.e. table, with sorting and groups?
Thanks for your help.
<HTML>
<!--The following token places the object name in the title bar of the Web
browser.-->
<TITLE><!--AccessTemplate_Title--></TITLE>
<!--The following HTML tag creates a different background color than the Web
browser default.-->
<BODY BACKGROUND = "gray.jpg">
<!--The following token places all object output inside the <BODY> tag.-->
<!--AccessTemplate_Body-->
</BODY>
<BR><BR>
<!--The following four tokens create four navigation text buttons that jump
to the first, previous, next, and last pages of a report.-->
<A HREF = "<!--AccessTemplate_FirstPage-->">First</A>
<A HREF = "<!--AccessTemplate_PreviousPage-->">Previous</A>
<A HREF = "<!--AccessTemplate_NextPage-->">Next</A>
<A HREF = "<!--AccessTemplate_LastPage-->">Last</A>
<!--The following token inserts the text "Page n" , where n is the current
report page number.-->
<P ALIGN = CENTER>Page <!--AccessTemplate_PageNumber-->.</P>
<!--The following HTML tag adds a company logo to the bottom of the Web
page.-->
<IMG SRC = "company_logo.jpg">
</HTML>