Hi there,

The FIRST(...) command only displays the first result, the other results have still been collected by the SQL statement and are held in memory. That's why when you do...

Hi there Ezytime,

I was using the paramaters to control visibility, however your second method was what I was hoping for, and it worked perfectly.

Thank you for your help!

Mikey