Fill in Null values

[Petefured]

Hi,

I have a problem with an Access table, I simplified the issue in the below attached zip file

There is a field that looks like this:

Field1
a

b

e

and the final results should look like this

Field1 Field2
a a


a
b b
b
e e
e

I tried using dlookup and dsum in a query but I did not succeed

Your help would be very much appreciated

Many thanks in advance!

[Petefured]

Sorry, just a correction:

the result should look like this:

Field1 Field2
a a
a a
b b
b b
e e
e e

ThX!