Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Access Query

by tx1epcs Mar 3, 2006 1:03AM PST

Hello all,

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..

Discussion is locked

1 Posts

- Collapse + Expand Details

- Collapse -

Re: Access query

by Kees Bakker Mar 3, 2006 2:40AM PST

George,

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.

Kees

Back to Office & Productivity Software forum