I've tried to make a subquery with a transform query inside but it seems it's not working. Does anyone know if this is a forbidden/non-implemented thing in Jet SQL?
My code look like this:
To boldly code, where no programmer has compiled before!
My code look like this:
Code:
SELECT FQ.AnyField
FROM [TRANSFORM FieldX SELECT blahblahblah... PIVOT yaddayadda... ]. AS FQ
To boldly code, where no programmer has compiled before!