repost Help with Select query

M

Mattias

Hi

I do not want to change any data!!

It just an example. If record2 is Null it is ok.
if record2 has 1.000.000 and it is the only one on the right side, it is
also ok.
If record2 has 1.000.000 and one more record on right side: 1.500.000..then
I would like the query only to show top value "1.500.000" on the right side.

Mattias
 
M

[MVP] S. Clark

Go back to your original post, and supply more detail about your starting
data.
 
Top