I've created a query to return all values in a table where 'Type' is 'A'
<tbody>
</tbody>
Can update queries update the blank 'TypeNumber' fields in sequential order based on the record above it?
E.g.: 'XXX' = 46, YYY = 47, ZZZ = 48
Type | TypeNumber |
A | 34 |
A | 35 |
A | 36 |
A | 37 |
A | 45 |
A | [XXX] |
A | [YYY] |
A | [ZZZ] |
<tbody>
</tbody>
Can update queries update the blank 'TypeNumber' fields in sequential order based on the record above it?
E.g.: 'XXX' = 46, YYY = 47, ZZZ = 48