If I change this to a custom or query with joins, then how woudl I get the total? Wouldn't this limit me to X records, regardless of how many records there are? I haven't used paged queries before
Was expecting this to be the case. Great, then I would have both indeed... I'll go with Ben's solution for now and turn it into a paged query when I got more data, as that would be more efficient