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 TouchToneTommy 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
- Content: Threads
- Order by date
-
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?
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
