Query ID number?

[kujito]

I've got my queries right so that they pull the correct pieces of data I need, but I would like to have a "queryID" field. I'd like to have the query results sorted in descending order based on my totals field. The largest total should be number "1" and the smallest should be, in one case, number "9". There is a unique "ProjectID" field, but the numbers are not sequential or in any numeric order when "TotalMO" is sorted (either ascending or descending).

Thanks,
Brian

 

[ajetrumpet]

take a look at the FAQ i just posted in the FAQ section regarding this. it's the newest one. it deals with numbered recordsets in queries.