Originally Posted by
June7
Consider:
Query: NamesSeq
SELECT Names.Group, Names.Name, DCount("*","Names","Group='" & [Group] & "' AND [Name]<'" & [Name] & "'")+1 AS NameSeq
FROM [Names];
Query: NumbersSeq
SELECT Numbers.Group, Numbers.Number, DCount("*","Numbers","Group='" & [Group] & "' AND Number<" & [Number])+1 AS NumSeq
FROM Numbers;
Query:
SELECT NamesSeq.Group, NamesSeq.Name, NumbersSeq.Number
FROM NumbersSeq INNER JOIN NamesSeq ON (NumbersSeq.NumSeq = NamesSeq.NameSeq) AND (NumbersSeq.Group = NamesSeq.Group);