Query field which displays record for specific facility from previous year (See Table)

[Bob Fitz]

Previous Balances: Nz(IIf("tbl_Sch2_Summary.[Index&Facility]= '" & [tbl_Sch2_Summary].[Index&Facility] & "' And tbl_Sch2_Summary.[Reporting Year] = " & ([tbl_Sch2_Summary].[Reporting Year]-1),[Balance SCUs],"Not Available"))

But that's not the expression I asked you to try

[Bob Fitz]

Cross-Posted: https://www.accessforums.net/showthread.php?t=79618

kennethnaga Please read this: https://www.excelguru.ca/content.php?184