I have a query that only has 4 fields: SalesOrder, SalesOrderID, FabSO, and PODate. When it is sorted by PODate it sorts as shown below:
qryUniqueSOFromtblTempFabReq
SalesOrderSalesOrderIDFabSOPODate
SDR0493443FAB0225/13/2025
SDR0503444FAB0225/13/2025
SDR0513447FAB0225/15/2025...