Matching records in sequence

[DatabaseWoes]

Does anyone know of a technique to match records in a query in sequential order?

For example, given two recordsets:

|Group|Number
|A |700
|A |701
|A |790
|A |799
|B |604


|B |605
|C |800
|C |801
|C |802
|C |803


|Group|Name
|A |Adam
|A |Bill
|A |Carl
|B |Dave
|C |Evan
|C |Fred
|C |Greg
|C |Hugh
|B |Ira

Is there a query technique that will take the first name, match the lowest available number in its group, go to the next name, match the NEXT lowest number available in the group, and so on?

The result might look like this:

|Number|Name
|700 |Adam
|701 |Bill
|790 |Carl
|604 |Dave
|800 |Evan
|801 |Fred
|802 |Greg
|803 |Hugh
|605 |Ira

Thanks.

[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);

[DatabaseWoes]

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);

Considered, tested, found to be brilliant.

Thanks so much!!