SELECT OrgName FROM #tblOrgs# WHERE OrgID = #URL.oid# SELECT * FROM #tblCases# WHERE OrgID = #URL.oid# Sustainable Building Resource Directory
Sustainable Building Resource Directory
[View Full Directory] - [View By Category] - [Organization Search] - [Product Categories]
Case Study: #qryOrgInfo.OrgName#
Architect / Builder
#qryOrgCase.ArchName# Website
  #qryOrgCase.ArchAddr1#
#qryOrgCase.ArchAddr2#
#qryOrgCase.ArchCity#, #qryOrgCase.ArchState# #qryOrgCase.ArchZip#
TEL: #qryOrgCase.ArchPhone#
FAX: #qryOrgCase.ArchFax#
#qryOrgCase.ArchEmail#
ADMIN: [Edit Case Study] - [DELETE CASE STUDY]
Project Information
Location: #qryOrgCase.ProjLoc# Picture 1 Picture 1
Size: #qryOrgCase.ProjSize# Picture 2
Total Cost: #DollarFormat(qryOrgCase.ProjTotal)#
Cost / Sqft.: #DollarFormat(qryOrgCase.ProjCostPer)#
Green Building Features: #qryOrgCase.ProjFeat#
Project Description: #qryOrgCase.ProjDesc#
ADMIN: [Edit Pictures]