Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
SELECT
U.[Last Name],
U.[First Name],
S.[Attachments]
FROM [Students] S Left Join [Union Query] U ON S.SomeUniqueField = U.SomeUniqueField
Nz(A.Attachments,Nz(B.Attachments,C.Attachments))
Duane said:having three tables rather than one