Cheers Greg, but unfortunately the trick won't work for me - as there's no join - it's just a single table. If I try to add another column then it needs to be grouped by this extra column - which then 'wrecks' the data I actually wanted to return
Though I did get around it all by using the get_recordset_sql() function
A
General developer forum
Using get_records_sql() - not all records returned
This discussion has been locked so you can no longer reply to it.