Experts, 

I am trying to make this query and I think I am pretty close but I dont know how to show the Current Date in the blue below? 

SELECT T1.Expirey2,T1.AmountOfChange, T1.LCID
(SELECT SUM(AmountOfChange)
FROM qryLCAmends AS T2

WHERE T2.LCID = T1.LCID
AND T2.Expirey2 < the current date)
AS LCBalance
FROM qryLCAmends AS T1
ORDER BY LCID;

the format of Expirey2 is like 9/17/2024

I think I need a NZ handler as well.

thank you

​Experts,  I am trying to make this query and I think I am pretty close but I dont know how to show the Current Date in the blue below?  SELECT T1.Expirey2,T1.AmountOfChange, T1.LCID(SELECT SUM(AmountOfChange)FROM qryLCAmends AS T2WHERE T2.LCID = T1.LCIDAND T2.Expirey2 < the current date)AS LCBalanceFROM qryLCAmends AS T1ORDER BY LCID; the format of Expirey2 is like 9/17/2024I think I need a NZ handler as well.thank you   Read More

​