I have a continuous form in a subform with a number of fields including Member & result which I sort by clicking on the column label.
What I want to achieve is when I sort on result it will show completed results first (in ascending order) followed by members whose results haven't been entered yet.
eg
Member Result
Fred 66
John 69
Alan
Brian
....
Any suggestions would be welcome... Thanks
What I want to achieve is when I sort on result it will show completed results first (in ascending order) followed by members whose results haven't been entered yet.
eg
Member Result
Fred 66
John 69
Alan
Brian
....
Any suggestions would be welcome... Thanks