Gary, unfortunately im using ASP for this one. Although, Access does support sub queries (well, i got one to work the other day). I did have a query *almost* work. But access got hung up on either table aliasing or left inner joins (or a combination of both).
Mark, i'll give your query a shot, gotta rename all the fields (i aliased everything). Thanks for the help/ideas everyone (on list and off) _______________________ James Silva Web Production Gruden Pty Ltd Tel: +61 02 9956 6388 Fax: +61 02 9956 8433 Email: [EMAIL PROTECTED] Web: www.gruden.com _______________________ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
