Nz(A.Attachments,Nz(B.Attachments,C.Attachments))
Thank for the advice but like you predicted, it did not work.
Unfortunately since SharePoint has a limit of 5000 items per list, so we are forced to move (archive) student files automatically using Microsoft Flow.
It just would be nice if all...
Thank you dhookom and Andrzejek
Sorry I'm going back and forth on this...
But this worked out great but unfortunately All Tables have attachments.
Is there a way to combine all attachments into one column? I have a form with a button that opens attachment management.
This is what I'm trying. I've simplified it so it's easy to follow.
(Union Query)
SELECT
[Last Name],
[First Name]
FROM [Students]
UNION ALL
SELECT
[Last Name],
[First Name]
FROM [Students Archive 2-4 years old]
UNION ALL
SELECT
[Last Name],
[First Name]
FROM [Students Archive 4-6...
thread700-1724615
Good afternoon guys, I'm very new to this.
I was just wondering if anyone can elaborate on what the code would look like for the answer by Programmer dhookom on thread700-1724615.
Any help would be really helpful. Thank you all!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.