SELECT * FROM activities_misc a
left join AttachmentLinks as b on a.act_misc_id = b.Object_id
left join Attachments as c on c.attachment_id = b.attachment_id
WHERE Firmid = 2 AND Caseid = 10062
ORDER BY act_misc_id desc
I want to do the first join to Attachmentlinks ONLY when b.Object_type = 'receipt'
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data.
A Microsoft Access subform is used to show relevant calcul…
With just a little bit of SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form. If you have never written code or looked at an SQL statement before, no problem! ... give i…