Search results

Hi Guys, I'm getting desperate...Whatever I do, doesn't work... Can someone pls convert below to a DSUM function for me? SELECT tblAreas.ID, tblAreas.Project, tblAreas.Cost From tblAreas WHERE (((tblAreas.ID)=[Forms]![frmProjectContractEntry]![AreaName]) AND...

Opps

Good morning all, Novice user here, trying to join 3 tables, namely tblContracts, tblProjects and tblInvoices.... Idea is to have a query to run a report - see Financial Report by Area, where it shows projects, associated contracts and associated invoices received , managed to join projects...