Date query not working

[PaulSharma]

SELECT count(Workitem) AS ["Total Workitem"]
FROM qryReport
WHERE qryreport.date >(08/10/2005); 'MM/DD/YYYY

Secondy how do i supply dates dynamically.

 

[fliflo]

you mean something like today date minus something???

for that try using the now() function and dateadd() function

 

[raskew]

Pat,

WHERE qryreport.date > DateAdd("d", 7, Date());

Wouldn't you want to use ...date>DateAdd("d", -7, Date())

Bob