Hello all,
My first post here: I am viewing my data in a Data Access Page (DAP), which is based on a query. In the DAP view, I drill down on the records I want to see by selecting from the alternatives in a drop-down. However, I would like to also see the totals.
Example: table/query retrieves 2 records:
Apple 4
Banana 3
I would like to see the accumulated value 7, before selecting Apple or banana in the drop-down. Can this be done in the query or in the DAP page in any way, or do I need to add a total line in my table? (Actual table is obviously not 2 records only, so this option is not preferable).
Thanks in advance for any inputs, and for all the great stuff on this page.
/v
My first post here: I am viewing my data in a Data Access Page (DAP), which is based on a query. In the DAP view, I drill down on the records I want to see by selecting from the alternatives in a drop-down. However, I would like to also see the totals.
Example: table/query retrieves 2 records:
Apple 4
Banana 3
I would like to see the accumulated value 7, before selecting Apple or banana in the drop-down. Can this be done in the query or in the DAP page in any way, or do I need to add a total line in my table? (Actual table is obviously not 2 records only, so this option is not preferable).
Thanks in advance for any inputs, and for all the great stuff on this page.
/v
