Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
UNION ALL with Attachment data type
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...- jjMedrano
- Post #8
- Forum: Microsoft: Access Tables and Relationships
-
UNION ALL with Attachment data type
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.- jjMedrano
- Post #6
- Forum: Microsoft: Access Tables and Relationships
-
UNION ALL with Attachment data type
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...- jjMedrano
- Post #3
- Forum: Microsoft: Access Tables and Relationships
-
UNION ALL with Attachment data type
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!- jjMedrano
- Thread
- Replies: 8
- Forum: Microsoft: Access Tables and Relationships
