BennyLinton
Registered User.
- Local time
- Today, 09:30
- Joined
- Feb 21, 2014
- Messages
- 263
i am trying to write a query that will sum all payments for a variable time frame, I'm kinda lost here.... thanks!!
Code:
SELECT DISTINCTROW Sum([dbo_Payments].[amount]) AS [Sum Of amount], Count(*) AS [Count Of dbo_Payments], dbo_Payments.transactionDate
FROM dbo_Payments
WHERE (((dbo_Payments.transactionDate) Between "StartDate" And "EndDate"));