Top Value Question

message from Ramone on 21 May 2004
Hello All,

I have a query that sorts dollar amounts and i would like
to create a field that assings a 1 to the top value and 0
to all other values. I was trying to use this statement

iif([amount]= top 1,1,0)

Thanks for any suggestions
 

Archived message: Top Value Question (MS Access Forms)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.