Syntax Question - MS Access Qry -> VB ASP

[CharlieMike73]

Can someone please help me convert this following MS Access SQL Query into a Query to be used on a VB-Script ASP page.

Or at least direct me to some program/site/tutorials that will help me.

I am trying to create the web page in Macromedia Dreamweaver MX, but get an error if I try to past the SQL from Access into the SQL Select statement.

Any help is appreciated!

Thank you,
Charlie

MS Access Code Below:

SELECT
   DBO_EMPLOYEE.LAST_NAME,
   DBO_EMPLOYEE.FIRST_NAME,
   Sum(DBO_WORK_REPORT_LABOR.REPORTED_HOURS)
     AS SumOfREPORTED_HOURS

FROM
   DBO_EMPLOYEE
     INNER JOIN (DBO_DAILY_WORK_REPORT INNER JOIN DBO_WORK_REPORT_LABOR
       ON DBO_DAILY_WORK_REPORT.DWR_SYS_ID = DBO_WORK_REPORT_LABOR.DWR_SYS_ID)
     ON DBO_EMPLOYEE.EMP_ID = DBO_WORK_REPORT_LABOR.EMP_ID

WHERE
   (((DBO_DAILY_WORK_REPORT.DWR_DATE)
     Between [Type Beginning Date:] And [Type Ending Date:])
   AND
   ((DBO_EMPLOYEE.UNIT_ID)>=5000
   And
   (DBO_EMPLOYEE.UNIT_ID)<6000))

GROUP BY
   DBO_EMPLOYEE.LAST_NAME,
   DBO_EMPLOYEE.FIRST_NAME,
   DBO_EMPLOYEE.EMP_ID
     HAVING
       (((Sum(DBO_WORK_REPORT_LABOR.REPORTED_HOURS))<40));

 

[onpnt]

I'd use a stored procedure then there isn't much to cahnge at all
reference

http://www.webconcerns.co.uk/asp/sqlqueries/sqlqueries.asp

http://www.aspin.com/home/tutorial/database/storedpr

---------------------------------------
{ str = "sleep is good for you. sleep gives you the energy you need to function";
ptr = /sleep/gi;Nstr = str.replace(ptr,"coffee"alert(Nstr); }
---------------------------------------
for the best results to your questions: FAQ333-2924

http://www.onpntwebdesigns.com

 

[mwolf00]

startDate = '12/12/2002'
endDate = '12/21/2002'

sql = "SELECT "&_
"DBO_EMPLOYEE.LAST_NAME, "&_
"DBO_EMPLOYEE.FIRST_NAME, "&_
"Sum(DBO_WORK_REPORT_LABOR.REPORTED_HOURS) "&_
" AS SumOfREPORTED_HOURS "&_
"FROM "&_
"DBO_EMPLOYEE "&_
"INNER JOIN (DBO_DAILY_WORK_REPORT INNER JOIN DBO_WORK_REPORT_LABOR "&_
"ON DBO_DAILY_WORK_REPORT.DWR_SYS_ID = DBO_WORK_REPORT_LABOR.DWR_SYS_ID) "&_
"ON DBO_EMPLOYEE.EMP_ID = DBO_WORK_REPORT_LABOR.EMP_ID "&_
"WHERE "&_
"(((DBO_DAILY_WORK_REPORT.DWR_DATE) "&_
" Between '" & startDate & "' And '" & endDate & "') "&_
"AND "&_
"((DBO_EMPLOYEE.UNIT_ID)>=5000 "&_
"And "&_
&quot;(DBO_EMPLOYEE.UNIT_ID)<6000)) &quot;&_
&quot;GROUP BY &quot;&_
&quot;DBO_EMPLOYEE.LAST_NAME, &quot;&_
&quot;DBO_EMPLOYEE.FIRST_NAME, &quot;&_
&quot;DBO_EMPLOYEE.EMP_ID &quot;&_
&quot;HAVING &quot;&_
&quot;(((Sum(DBO_WORK_REPORT_LABOR.REPORTED_HOURS))<40))&quot;
Get the Best Answers! faq333-2924
Happy 2003!
mikewolf@tst-us.com

 

[onpnt]

or that ---------------------------------------
{ str = &quot;sleep is good for you. sleep gives you the energy you need to function&quot;;
ptr = /sleep/gi;Nstr = str.replace(ptr,&quot;coffee&quot;alert(Nstr); }
---------------------------------------
for the best results to your questions: FAQ333-2924

http://www.onpntwebdesigns.com