show sum of results only for last 7 days on a form

[LoveLearning]

Hi,

I am trying to sum a field (Minutes) only if the date field (ServiceDate) is 7 days prior to todays date. Any suggestions to help would be appreciated? I have played around with the IF statement, yet not having much luck.

[recyan]

Just check if below gives some guidelines :

SELECT 
	Sum(myTable.TheMinutes) AS SumOfTheMinutes
FROM 
	myTable
WHERE 
	(
		(
			(myTable.ServiceDate) Between Date() And Date()-7
		)
	);

Thanks

[LoveLearning]

That worked....Thanks so much!

[recyan]

Glad you found it helpful.

Thanks