Copy Data into a Field

[IvanMtz]

Hello guys this might be a silly question but let me explain it 

I have a database that looks like this

Customer Code     OrderNumber     Value

     000001                    0001             100

     000001                    0001                   

     000002                    0002             200

     000002                    0002                   

So i need to put the same information where is blank without losing the other information  

Customer Code     OrderNumber     Value

     000001                    0001             100

     000001                    0001             100     

     000002                    0002             200

     000002                    0002             200     

Thank you so much for all your help 

Regards

Ivan

[DataNath]

No such thing as a silly question! Would this do the trick? If not, let me know the logic/conditions behind what it can be filled by when you apply it to real data and I'll have another stab!

[IraWatt]

Hey @IvanMtz,

Do you need a SQL query to solve this? By the looks of your example you can use a multi row formula. The formula I used checks if the current value is NULL if so take the value from above else just use the value it has.

If you have any questions make sure to ask :)

HTH,

Ira