Search results

I'm still having trouble but only because I want to maybe expand on this to try and generate a report that shows every machine we have, which spares match. Rather than just taking the queries you guys have kindly provided. I'm trying to get my head around them so I understand how they work and...

Hi, me again I've been rebuilding queries similar to Mihail's but it already seems to work on machines with subsets of replaceable parts, but as far as I can tell Mihail's queries work like Geo's in terms of comparing parts, am I missing something here? Is this working by coincidence?

This is great - thanks! It probably sounds really daft but the visual element really helped me get my head round what the queries are actually doing. I'm trying to use this alongside Geo's more split out queries to give me a basis for finding parts when they're part of a larger part set from an...

Thanks for that. I'll give it a bash and see if I can work on what you've given me to help out, in all honesty, you've already managed to flip my approach on it's head. Which is a great thing as I'd spent the last few hours trying to do something that clearly wasn't working!

Thanks for your help, that's given me a great starter for ten, I was trying to fit it into one or two queries, maybe I'm not breaking it down enough. Sorry, just for my own understanding here, you've done 1. Select all the fields from CurrentMachines 2. Counted the number of parts each of our...

Hi all, I've found myself in a bit of a nightmare situation, in that I did Computing at college (a good while back!) and my manager has a database they would like me to query. However, its very old and the DBA retired 5 years ago. I've opened it up and it seems like a mess to me, but I'm sure...

Hi all, I'm Matt, 24 and from the UK. I currently work in a textiles factory. Hobbies include walking and cycling but I don't have the money for the right kit for either!