Myriad_Rocker
Questioning Reality
- Local time
- , 19:38
- Joined
- Mar 26, 2004
- Messages
- 166
Why will this not work? I've done a search for the error and I don't get much help. I also tried Google, which yielded no help. I don't get it. Here's my SQL...the subquery returns 22 records.
SELECT Count(SELECT DISTINCT [Client]
FROM [Project Administrator Work Requests]
WHERE [Request Date] Between ((Date()-Weekday(Date())-6)-49)
And ((Date()-Weekday(Date()))-49)) AS WK1
FROM [Dummy]
SELECT Count(SELECT DISTINCT [Client]
FROM [Project Administrator Work Requests]
WHERE [Request Date] Between ((Date()-Weekday(Date())-6)-49)
And ((Date()-Weekday(Date()))-49)) AS WK1
FROM [Dummy]
