Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.
SELECT qryRepaid.FacilityAmount, (Select Sum(T.Amount) From qryRepaid As T Where T.ID_Facility=qryRepaid.ID_Facility And T.ValueDate <= qryRepaid.ValueDate)-Sum([Amount]) AS [Beginning Balance], [facilityamount]-[beginning balance] AS bal FROM qryRepaid GROUP BY qryRepaid.FacilityAmount;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Check a field in Access on a Timer||1||32|
|Troubleshooting Save_Record_Click() VBA||6||22|
|MS Access Recordset Need Help Setting All Record Values In A Query To False (No)||6||16|