Recent content by Oscar42

Yep, have just changed them all. I will have to use spaces in the Alias's though as these are what the user eventually sees in the 3rd party applications so want it to be nice readable.

Well spotted. At the moment the query result is read by two different 3rd party applications. One of those applications requires fixed naming conventions but it is not read by the user. The second application requires it to be a user friendly name. The non-required field in both cases can be...

OK, Many Thanks for helping out a newbie. As you say Access won't keep the formatting so maybe I'll edit and version control it through another editor. Cheers

Yes, it's functionally fine, just difficult to read and maintain. Is there any way to break such a thing up into more manageable portions? Like the WITH stmt?

Hyper links removed..

SELECT [Standard Parts].[Contromax Part Number], [Standard Parts].[Part Catalog], [Standard Parts].Description, [Standard Parts].[Schematic Comment] AS SchComment, [Standard Parts].[Symbol Path] AS [Library Path], [Standard Parts].[Symbol Name] AS [Library Ref], [Standard Parts].[Footprint...

Yeah I've tried that, but I still get...

I tried but it wouldn't let me post. It says it thinks it is some dodgy code :(

I have this now but it's missing a pile of IFF statements:

Thanks all. I get it now that I don't need to use a UNION. Just some complex IFF statements in the select query. This will make the select query enormous. Any recommendations on how to break up a very complex/large SELECT query? I'm going to try and use Access Studio to help at least visualise.

I've got 28 queries collecting a sub-set of table data based on a single criteria in a field of the QBE. Now some of the those 28 queries exclude certain fields. What I ideally want is a final query result that combines all those queries. I have tried UNION but that is not compatible with my...