Thanks for the reply Mehere!
Here is the view i'm using:
Code:
SELECT dbo.tblEQStatus.RegionID, dbo.tblEQStatus.ToolID, dbo.tblEQStatus.DistrictID, dbo.tblEQStatus.EQStatus, dbo.tblEQStatus.TrackingStatus,
dbo.tblEQStatus.EQNumber, dbo.tblEQStatus.Loc, dbo.tblEQStatus.CurrCC, dbo.tblTools.Tools, dbo.tblRegion.RegionName,
dbo.tblDistricts.District_Location
FROM dbo.tblTools RIGHT OUTER JOIN
dbo.tblEQStatus INNER JOIN
dbo.tblDistricts INNER JOIN
dbo.tblRegion ON dbo.tblDistricts.RegionID = dbo.tblRegion.RegionID ON dbo.tblEQStatus.DistrictID = dbo.tblDistricts.DistrictID ON
dbo.tblTools.ToolID = dbo.tblEQStatus.ToolID
WHERE (dbo.tblEQStatus.Loc LIKE '%ready%') OR
(dbo.tblEQStatus.Loc LIKE '%repair%')
Right now on my results.
asp page, I have something like this:
Region
---AB-Repair--Tools---EQNumber
---AB-Repair--Tools---EQNumber
---AB-Ready--Tools---EQNumber
---DU-Repair--Tools---EQNumber
---EH-Ready--Tools---EQNumber
Next Region
Etc.
The LOC field contains hyphens (AB-Repair)
I didn't know if there was a way to use an if statement with code below to say if LOC contains ready then show all the ready, then if repair show all the repair.
Code:
<TR>
<TD bgcolor=#ffe4e1 align=right><%=rs("Loc")%> </TD>
<TD align=center><%=rs("Tools")%> </TD>
<TD align=center><%=rs("CurrCC")%> </TD>
</TR>