Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: cthesupremeg
- Order by date
-
Counting the # of open tickets for each day w/ only open/closed dates?
Thanks again for the info. It was a bad assumption on my part that the following information would not be needed to identify the solution to my problem in my original post. (I appreciate the response. I wish my problem was that simple.) The Data: I am extracting ticket records from Remedy (our...- cthesupremeg
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Counting the # of open tickets for each day w/ only open/closed dates?
I am trying to figure out how to create a query/report in MS Access that will show me the number of open tickets at the end of each day using only the open date and close date of the ticket. For example, if I have the following data set: Ticket Opened Closed 1 1/2/08 1/3/08 2...- cthesupremeg
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
Can MS Access count open tickets by day with only start/end dates?
Thanks for the response. I'll refine my inquiry and post it where you suggested.- cthesupremeg
- Post #3
- Forum: Microsoft: Office
-
Can MS Access count open tickets by day with only start/end dates?
I am trying to figure out how to create a query/report in MS Access that will show me the number of open tickets at the end of each day using only the open date and close date of the ticket. For example, if I have the following data set: Ticket Opened Closed 1 1/2/08 1/3/08 2...- cthesupremeg
- Thread
- Replies: 3
- Forum: Microsoft: Office
