datatype date as text?

[JoeM]

Take your time. I actually won't be able to download the file until I am home tonight (corporate policy). But I will look at it!

[slimjen]

Ok. I attached a sample I hope you can use. I am trying to create a query to get the number of calls received weekly and a count of the calls completed weekly. Thanks for you help

[JoeM]

Aha! Just as I thought! It is a data issue. You have 5 records which cannot be converted to valid dates, like "3/37/01".
The 5 offending record IDs are:
436
1168
5368
13654
16051

Remove or correct these records, and then the query works!

[slimjen]

Got it to work. I new I needed another set of eyes because I was looking at this too long. Thanks so much for your help!

[slimjen]

Ok Now another problem. I've been trying to get a count by week and not having much success. I used another query grouped on CallsRecd and used this in the criteria:

Format(([Calls Recd]-Weekday([Calls Recd]))+1,"mm/dd/yyyy")

No results

[JoeM]

I have been out of town for a bunch of days, and am just getting back to things.
I see you posted some other questions, so has this one already been addressed?

[slimjen]

Thanks for coming back. I am still working on it. I started a new thread : count # for current week. I'm pretty close.