Jim Crews
|
Posted: 06/20/2002, 10:44 AM |
|
I am using ASP w/ Templates, CC 2.0.5, and NT4sp6
I have 4 grid forms on a page, (f1 - list name and other information; f2 -
some records from table related to acct; f3 - more records from table
related to acct).
The problem I am having is with f4. I would like to sum the values in the
f2 and f3 for acct, but I get total sum of all records in table.
What do I need to include to only sum the related records.
Thanks
Jim Crews
United Methodist Church of SC
|
|
|
LW Irving
|
Posted: 06/22/2002, 4:14 AM |
|
make the query you need in access
then add it to your form in ths custom sql section
Wayne
"Jim Crews" <jcrews@umcsc.org> wrote in message
news:aet49h$ndk$1@news.codecharge.com...
> I am using ASP w/ Templates, CC 2.0.5, and NT4sp6
>
> I have 4 grid forms on a page, (f1 - list name and other information; f2 -
> some records from table related to acct; f3 - more records from table
> related to acct).
> The problem I am having is with f4. I would like to sum the values in the
> f2 and f3 for acct, but I get total sum of all records in table.
> What do I need to include to only sum the related records.
>
> Thanks
> Jim Crews
> United Methodist Church of SC
>
>
|
|
|
|