Simple? Query Question

[Stacy]

What query would I use to count the help desk tickets closed and opened if the data is setup like this?



DateOpened Ticket Name Date Closed
1/1/10 123 Jill Jones 1/2/10
1/1/10 124 Jill Jones 1/2/10
1/1/10 125 Jill Jones 1/3/10
1/2/10 321 Bob Green 1/3/10

Desired Result
Date Name DateOpened DateClosed
1/1/10 Jill Jones 3 0
1/2/10 Jill Jones 0 2
1/2/10 Bob Green 1 0
1/3/10 Jill Jones 0 1
1/2/10 Bob Green 0 1

[ajetrumpet]

select date, name, count(dateopened), count(dateclosed)

from table

group by date, name

[Stacy]

You said select date, but which date or both dates?

select date, name, count(dateopened), count(dateclosed)

[ajetrumpet]

sorry. I guess I read that wrong. It's more complex...

I apologize Stacy, now that I read it, nothing comes to mind right now. You're welcome to upload your file and someone can take a look when they get time. I'm sure I can figure out how, but I can't at this moment. Doing other things.

Sorry...usually I can do it off the top of my head. But not today apparently!

[Stacy]

I've attached a text file, so you can see the data I'm dealing with. Thanks.

[ajetrumpet]

that doesn't help Stacy. That's the same as reading your first post.

Upload the file.

[Stacy]

I'm stumped, so any help is appreciated.