C
Cayvman
Okay, let me try this again with a pared down sql script. I was able to do
the formatting on one of the my queries, however am still stuck on the first
query. So, here is the query that I still need help in sending the
information to Front Page to format the results of the Hours field.
The fields in the access database are ID,Employee Name,Project,Hours,WED
The Table name is WPLR.
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM WPLR WHERE (Project LIKE ':roject::%' AND WED =
'::WED::') ORDER BY ""Employee Name"" ASC"
fp_sDefault="Project=&WED="
fp_sNoRecords="<tr><td colspan=4 align=""LEFT"" width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="ProjLab"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="WED"
fp_sMenuValue="WED"
fp_sColTypes="&ID=3&Employee Name=202&Hours=5&Project=202&Fiscal
Year=3&Period Number=3&Sub Period Num=3&WED=135&"
fp_iDisplayCols=4
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
The script for a second query that sums the results of the first query
follows. Though this script is more complex, I was able to get the format
syntax right. Which came as a shock to me.
SELECT *,
(SELECT sum(Hours) FROM WPLR WHERE (Project LIKE
':roject::%'AND WED = '::WED::')) as [Total Hours]
FROM WPLR WHERE (Project LIKE ':roject::%'AND WED = '::WED::') ORDER BY
Hours ASC
Any suggestions will be greatly appreciated. I have over 16 hours into this
seemingly simple web-based reporting system.
Joe
the formatting on one of the my queries, however am still stuck on the first
query. So, here is the query that I still need help in sending the
information to Front Page to format the results of the Hours field.
The fields in the access database are ID,Employee Name,Project,Hours,WED
The Table name is WPLR.
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM WPLR WHERE (Project LIKE ':roject::%' AND WED =
'::WED::') ORDER BY ""Employee Name"" ASC"
fp_sDefault="Project=&WED="
fp_sNoRecords="<tr><td colspan=4 align=""LEFT"" width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="ProjLab"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="WED"
fp_sMenuValue="WED"
fp_sColTypes="&ID=3&Employee Name=202&Hours=5&Project=202&Fiscal
Year=3&Period Number=3&Sub Period Num=3&WED=135&"
fp_iDisplayCols=4
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
The script for a second query that sums the results of the first query
follows. Though this script is more complex, I was able to get the format
syntax right. Which came as a shock to me.
SELECT *,
(SELECT sum(Hours) FROM WPLR WHERE (Project LIKE
':roject::%'AND WED = '::WED::')) as [Total Hours]
FROM WPLR WHERE (Project LIKE ':roject::%'AND WED = '::WED::') ORDER BY
Hours ASC
Any suggestions will be greatly appreciated. I have over 16 hours into this
seemingly simple web-based reporting system.
Joe