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!

Attached Files

db1.zip (9.8 KB, 1 views)

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!