Hi everyone.

I managed to get this working in Excel with the help of some people. The thread posted is here.
Solved: Conditional Sorting
I want to do exactly the same thing in my Access table. I have very little knowledge in both Access and in VBA.

I have some fields in my table that needs to be sorted in a specific way. The first field has numbers (including decimals) or is blank, and is the most important. I need code that will grab just the records that have a value (more than 0) in the first field and then sort them by field 2, 3, and then the fourth field. Then place all of these records at the top of table.

Hopefully someone can help me.