Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
CREATE TABLE Integers
(Num Long, CONSTRAINT Num PRIMARY KEY (Num))
INSERT INTO Integers (Num) Values(0)
INSERT INTO Integers (Num) Values(1)
:
INSERT INTO Integers (Num) Values(9)
Select 10*I1.Num + I2.Num As [N]
From Integers I1, Integers I2
SELECT EmployeeID,
Mid("," & E.Children & ",",
S1.N + 1 ,
S2.N - S1.N - 1) AS [Child]
FROM tblEmployees AS E, qryInt2 AS S1, qryInt2 AS S2
WHERE Mid$("," & E.Children & "," ,S1.N , 1 ) = ','
and Mid$("," & E.Children & "," ,S2.N , 1 ) = ','
and S1.N > 0 AND S2.N > 0
and S2.N <= Len(E.Children) + 2
and S1.N + 1 < S2.N
and InStr(1,Mid("," & E.Children & ",",
S1.N + 1 ,
S2.N - S1.N - 1),",")=0
ORDER BY 1, 2;