Top Value Question

[Ramone]

Hello All,

I would like help with the following question:

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