SELECT *
FROM (SELECT A.[Customer], A.[Date] AS [Date], (SELECT NZ(Sum(Se)) - NZ(Sum(Re)) FROM Detail1 AS B WHERE A.[Date] > B.[Date] AND A.Customer = B.Customer) AS PHY, Sum(A.[Se]) AS Se, Sum(A.[Re]) AS Re, [PHY]+Nz([Se])-Nz([Re]) AS Total
FROM Detail1 AS A
WHERE (A.[Date])>=(SELECT Min([Date]) FROM Detail1 AS B)
GROUP BY A.[Customer], A.[Date]
ORDER BY A.[Customer], A.[Date]) AS TTT;

รันใน Access 2003 เปิดได้ปกติครับ
แต่พอรันใน Access 97 มันขึ้น "Syntax error in FROM clause"
ไม่ทราบว่าต้องแก้ตรงไหนครับ