Access form

[duddu]

SELECT CS.[Agent Name], Count(CS.Score) AS CountOfScore
FROM CS
WHERE (((CS.Score)<85)) AND (DatePart("w",Now()) AS now, Now()-DatePart("w",Now()) AS lastsaturday, Now()-DatePart("w",Now())-6 AS lastsaturdaybeforesunday)
GROUP BY CS.[Agent Name];


Hi, I’m trying to display only 7 day data from table. But I’m getting error while doing this please help me.



Thanks.


Sent from my iPhone using Tapatalk

[John_G]

It would help if you told us what the error is. However, "as Now" might be causing an error because you can't use the "now" as an alias - it is the name of a function. Change "Now" to "RightNow" or something like that.

More importantly, I know this is wrong:
(DatePart("w",Now()) AS now, Now()-DatePart("w",Now()) AS lastsaturday, Now()-DatePart("w",Now())-6 AS lastsaturdaybeforesunday)

It evaluates to 3 values inside brackets and separated by commas: (Integer as now, Date1 AS lastsaturday , Date2 AS lastsaturdaybeforesunday). This "expression" is meaningless. What is it you want that WHERE clause to say, i.e. CS.Score < 85 AND ????. ANS what - in plain English.