raydan
Registered User.
- Local time
- Yesterday, 23:37
- Joined
- Aug 24, 2005
- Messages
- 28
SELECT Commissions.TransactionID, Commissions.OriginatorID, Commissions.AmountPaid, Commissions.DatePaid
FROM Commissions
WHERE ((Commissions.DatePaid)> DateAdd("d", -32, Date()));
I want to add up commissions paid in a month using a simple query and im not sure how to proceed from here. This example will pull records for the last 32 days, but now how do I do the sum commissions.amountpaid to work?
Thanks for any help.
Scott
FROM Commissions
WHERE ((Commissions.DatePaid)> DateAdd("d", -32, Date()));
I want to add up commissions paid in a month using a simple query and im not sure how to proceed from here. This example will pull records for the last 32 days, but now how do I do the sum commissions.amountpaid to work?
Thanks for any help.
Scott