Some Assistance with sorting via VBA code

[RachelBedi]

Hi There - I have forms currently being sorted by the date of enrollment (ascending) - I have since been asked to add an additional level of prioritization so that if the field "DMNumber" has a value that those should be at the top regardless of what the date of enrollment is.



Is there any way that I can write an if statement to bring those to the top of my datasheet view in my form?

Thank you guys!

[RuralGuy]

Does the DMNumber need to be in some order at the top of your datasheet, like numerical? Can you add another field to your table?

[RachelBedi]

I don't need it to sort in any particular way - just if there is a dm number there I need it at the top - I could add a field but I would prefer not to if I don't need to!

[RuralGuy]

Sort the DMNumber field descending.

[RachelBedi]

well I know I can do that but I still need it to sort by the date of enrollment ascending....

[RuralGuy]

You can sort on both, just sort on the date first. The query designer can help you here. Move the column to the left that you want sorted first. You can also specify asc/desc in design view and Datasheet view will show you what you will get.

[RachelBedi]

ohhhh...yeah that makes sense.

Thank you!

[RuralGuy]

Go ahead and use the Thread Tools at the top of the thread to mark this thread as Solved if it works as you want.