Simple Query

[tombsy]

I have a simple query that I just cannot get to work.

Fields......
ID (Primary)
Station (duplicates)


Offset
X
Y
Z

I want 1 record for station using the minimum X value.

EX: if (Station/X) are 20/2 20/3 20/4 20/6, I want one record to show 20/2 only. Make sense?

I tried using the Min function but its not working properly.

Thanks

[orange]

What exactly isn't working? What error message did you get?
Please show us the SQL for the query.

[tombsy]

I figured it out. I removed the ID (Primary field) and it worked.

Thanks