Thanks,
Like I mentioned, the query runs: (the "*" are necessary for the file import to Xero, all the fields are in the group (or it wouldn't run) - but I hadn't thought about deconstructing the query to find out which part is stopping it working! So thanks for that, I'll give it a try.