deejay - 11:02 pm on Oct 5, 2010 (gmt 0)
*lol* well if inspiration strikes, do come back and share please!
It's silly isn't it? This isn't the first time over the years I've had to do just this - mostly in Access though - it seems silly that there isn't a clean way round it.
Ideally maybe a subquery, but I need to be able to delimit the subquery by a field from the top query.
Gaah... would just be so much cleaner if I could do it in the initial query.