Hello,

  I have a table(msaccess) with the structure...
job_code text 6
style text 10
qty number
fabrication text 65
ship_date date/time


I want to show a report like...

job_code style qty fabrication ship_date
------------------------------------------------------
05A001 2464 75000 AAAAAAA 5-Jan-2005
05A002 3800 93430 BBBBBBB 5-Jan-2005
05B001 2845 4900 CCCCCCC 5-Jan-2005

                  ----------
                   173330
05A003 2564 45000 DDDDDDD 5-Feb-2005
05B002 2800 65000 EEEEEEE 15-Feb-2005
05C001 P357G 5500 FFFFFFF 15-Feb-2005
                 ------------
                   115500

....

What could be the query and how can i show an HTML report. I am using ADO with ASP and VBScript.


thanx in advance

There should be a better solution out there..but

I would try using a dynamic SQL something like this...

Dim var_Month

For var_Month=1 To 12 Step 1

SQL = "SELECT job_code,style,qty,fabrication,ship_date FROM MyTable WHERE Month(Ship_Date) = " & var_Month & "

'create your recrodset and display your results

Next