sort fields but make blank fields last instead of at beginning

[survivo01]

I have a query that lists people available for classes. There is ranking for who should go into the class first. However, some people have no ranking. Is there a way when I sort the field rank that the blank fields are at the end instead of at the beginning.

ID	Class	time	Rank
100	ABe
101	GED
102	1a		1
103	2a		2
104	3a		2

[pbaldy]

Try adding a calculated field to the query:

RankSort: Nz(Rank, 999)

and put the primary sort on that.

[survivo01]

Thanks again worked perfectly. Do You have any suggestions on courses to take or books to read so I can learn more.

[pbaldy]

I haven't read any of the recent books, so I'm not in a position to recommend one. I learned most on forums like this one.