Hi Tim

Please could you help me to find a solution for the the below code
that the sort of field (ID) i need it randomly instead of DESC
I'm using mdb, asp page and i'm not proffecional in farmating codes

fullOrderBy = " ORDER BY mainoffer.Id DESC"
the code fullOrderBy i need it to use it in other part of page
Thanks

SELECT <what_to_select>
FROM <table_name>
WHERE <criteria>
ORDER BY NEWID()

- Doc

Progress is made by the discontent.