for your trouble in http://www.access-programmers.co.uk/forums/showthread.php?t=171974
try this:
SELECT TOP(100) PERCENT WITH TIES HairID, HairDescription, HairShort, DisplayOrder
FROM bruce.Hair
ORDER BY DisplayOrder
try this:
SELECT TOP(100) PERCENT WITH TIES HairID, HairDescription, HairShort, DisplayOrder
FROM bruce.Hair
ORDER BY DisplayOrder