ASP Help Needed

[Kaushik Mandal]

Hi

I need some help with the ASP . I need to know how to make Grand total
based on Dates . I have the sub total for the dates and like to make
grand total for same dates . Please see the example below


Date Sub Total Grand Total

04/25/2005 $34

0425/2005 $89

04/25/2005 $78 --------

04/26/2005 $34

04/26/2005 $56
------
04/27/2005 $23

04/27/2005 $90
--------

What I would like to know is that how to make Grand total by dates .
Grand totals for 04/25 ,04/26, 04/27 using ASP . I need to do it on the
ASP page .

I am using MS SQL server 2000 as database

Thanks



*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***

[Master Dev]

Hi!

This is interesting, and I needed an answer to this too, once. Use datetags,
for example. What you can do is provide an extra (numeric) field that is the
sum of all the days since (say) 01 jan 2000. Use datediff() to do the math.
Then, sort on that field. Derive the difference, again, using datediff()

Or, dont touch the database (best practice - if you did a PORPER analisys
beforehand you may not neet to) and use datediff to get to these dates that
you need....
It seems possible to use VBS functions in SQL...

Annother tip, (maybe) is to use this syntax #dd/mm/yyyy# (or whatever your
dateformat may be) to force strict reading...

(all this of the top of my head, been late last nite, clarity to be added as
needed....)

happy coding!


--
--------------------------------------------
All is Haiku, even the chant of the wind


"Kaushik Mandal" wrote:

>
> Hi
>
> I need some help with the ASP . I need to know how to make Grand total
> based on Dates . I have the sub total for the dates and like to make
> grand total for same dates . Please see the example below
>
>
> Date Sub Total Grand Total
>
> 04/25/2005 $34
>
> 0425/2005 $89
>
> 04/25/2005 $78 --------
>
> 04/26/2005 $34
>
> 04/26/2005 $56
> ------
> 04/27/2005 $23
>
> 04/27/2005 $90
> --------
>
> What I would like to know is that how to make Grand total by dates .
> Grand totals for 04/25 ,04/26, 04/27 using ASP . I need to do it on the
> ASP page .
>
> I am using MS SQL server 2000 as database
>
> Thanks
>
>
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
>