Sleeper: VBA Code to Sort problem !

[Keith01]

That is not VBA code, it is SQL.

Should provide sample data and desired output. Can build tables in post or attach file.

Thank you very much for your reply June7

I attach a copy of the DB, what i am trying to achieve is to place a command button on the form that displays the form in either "Regn" Order or type "Order", but because of the underlying query this is proving to be very hard

Any advice would be much appreciated

Regards

Keith