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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with select query 9
IIF Function Within A Query 6
Query that autonumber some columns 3
Update Question 2
Finding records with equal values in 3 fields 6
Report format 2
Select/Change values of previous records 1
How to put multiple values in one field 3

Top