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!