If the web page is STATIC (say, refreshed once a week) I would simply export the report to html-format.
If it's DYNAMIC you have to resort to some server side programming, I'm afraid. Access data pages don't offer what you need (at least not in the versions of Access up to 2000).
The work-around may be to work with UNION queries. One query for the detail, one (with exactly the same fields) for the totals (make some group by query) and then a union of the two to fill the page.
Hope this helps.
I have an Access report that is grouped and works like a charm especially with the calculations in the footer area of the report that adds up each indvidual group and counts, percentage formula's and so forth.
Here is my problem....I need to display this bring this information into a web page but an Access Report is not a valid data source, only the tables and queries. Is there anyway to add up columns in a query? I did a query that groups the field and then sums or counts other data of those fields. But I need two more fields in that query,
1. A field that will add up all the sums of each group (basically summing up a column)
2. A field that I use an expression to get a percentage....which in case I need the grand total of all the groupings
Hope I have explained good enough what I need...and sure do hope somebody has some insight...Thank You much in advance..