Randy Lane
|
| Posted: 05/06/2002, 8:28 PM |
|
Hello all,
I am trying to set up a site for my company to keep track of billable hours
to clients and maybe more in the future.
My question is how can I easily total a column of numbers (Hours) after
selecting a date range (The last week..month..whatever) and a client and a
consultant.
I'm using CodeCharge 2.0, SQL Server and IIS outputting to ASP
Randy
|
|
|
 |
Alexey Alexapolsky
|
| Posted: 05/07/2002, 5:32 AM |
|
In Open event of grid form that displays your result ,
obtain sql statement from sSQL variable and replace it's
field list (string data between SELECT and FROM) with COUNT(*)
Save this new sql statement to some global variable.
This count sql will be used in the next form that diplays totals.
The latter form should have
sSQL = global_sql
in Form/Open event.
--
Alex
CodeCharge Developer
"Randy Lane" <randy@crystalimagesoftware.com> wrote in message
news:ab7hks$26v$1@news.codecharge.com...
> Hello all,
>
> I am trying to set up a site for my company to keep track of billable
hours
> to clients and maybe more in the future.
> My question is how can I easily total a column of numbers (Hours) after
> selecting a date range (The last week..month..whatever) and a client and a
> consultant.
> I'm using CodeCharge 2.0, SQL Server and IIS outputting to ASP
>
> Randy
>
>
|
|
|
|
|
