Thread:RR3 Michael P/@comment-27006659-20170319151020/@comment-30967537-20170426190434

Every so often I write a post, click on "Reply" and my post vanishes, very annoying! Not sure I can remember everything I just wrote!

--

Michael,

Sorry for the delay in responding, I was working on some other queries, but I realised that they were becoming more of an exercise in PQ so I stopped!

I've just posted a new spreadsheet here ...

https://drive.google.com/open?id=0B2-oGcug6THkWUxwNUVpOUhwV1k

The name has changed again to better reflect the expanding nature of the spreadsheet.

I kind of lost track of what I was supposed to be delivering! All of the queries have been tested and work. There are a couple of work-in-progress queries so they are missing some of the data I meant to inclide.

See the Read.Me sheet for a list of the queries and what they do ... let me know if they do (not) give you what you need ... I added the qInfo queries for you so let me know if they're not right and/or if you need the data concatenated.

I've included the qCarsMinUpgrades query which I improved so it runs in about half the time, still slow but definitely faster than it was. On the back of that query (and the called function) I thought it might be nice to add two user queries ...

1. qMinUpgradesCar. Return minimum upgrades for all series for the specified car.

2. qMinUpgradesSeries. Return minimum upgrades for all cars for the specified series.

I started working on an Integrity query but it was getting a bit out of control (checking too many things) so I thought it better if you tell me what you want checked.

I'm sure I wrote some other stuff but I can't remember!

Nick