Also....

I need it to return events that are not present;

AgentID   A   B   C .... Z

with zero's in the empty columns....

I am now assuming I need a while / wend type...

Ok... I can see that working (although all it does is create the same query I would have created anyway....)

But how does that translate to a single ADO type Query...