Challenge #135: Locker Problem

[olivia_paquot]

Done :-)

[simonpain]

I first did it using a bit of python 'cos I'm a developer so that's how I think but that felt like cheating so after having a sneaky quick look at some of the other answers layouts I tried a cross-join approach.

Spoiler

[DawnR]

Learning new things today.

[lminors]

Spoiler

Great opportunity to refresh the iterative macro skills.

[GarthMiles]

only requires 1 tool

Spoiler

[petgrap]

Spoiler

 

[richard_butler]

Ran query with a join rather than a macro to see if it would be quicker

[jezknee]

Solution attached. This was a particularly satisfying weekly challenge.

[Carlithian]

Tricky getting my head around the iterative macro, lots of fun though

[estherb47]

Really getting the hang of iterative maros :)

Spoiler

The workflow:


The Macro: