Perfect, this is exactly what I needed! I will need to review your Dynamic Cross-Tab section as strLoginID with access will vary widely based on the idSpecOrder.

Thanks for working on...

It works like a dream. Thanks for all your help.

Wow, thanks for the quick reply.

I ran the query but it kept complaining that 'RMax2.Ticket_ID' was an unknown column. So I modified it a bit and it seems to...