shaimaa.tarekelshoeiby (8/25/2014)
Oh, an important question regarding the joinI learnt about using CTE instead of a view so that I can do it all as sql queries
However , adding the With part doesn't work with Access.
Is there anything that can be similarly done in Access (or should I be moving to a new thread?)
Thanks a lot in advance!
I'm afraid that in Access you will have to stick with views.
😎