Facility ID Reporting Year Balance Previous Balance 101A 2019 5000 4000 101B 2019 4500 3500 101A 2018 4000 - 101B 2018 3500 -
Hi there,
I'm very new to Access/VBA/SQL and need some help creating the previous balance field in the table above. Please note: I do not know SQL and have been using the expression field in design view of the query. If this solution requires SQL, I would need instructions on how to implement it.
I'm trying to make a query which cross-checks values, in this case it's the balance field. In the previous balance field, I want to display the balance from the previous year for a particular Facility ID. In Excel, the SUMIFS function was used, but as far as I'm aware this does not exist in Access. Any help regarding this issue is greatly appreciated and if anything is unclear please let me know, thank you!
Edit: The pattern of FacilityID and Reporting Year is not consistent (does not alternate back and forth between 101A and 101B as shown).