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 derfloh 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: mgrover2k2
- Order by date
-
Counting new, open and closed items by month
CR 9 MS Access 2000 I have a table with: Item ID Open Date Closed Date I'm trying to build a report grouped on month that summarizes: -How many items were still open at the end of the month and what was the average age of the items. -How many items were closed during the month and what was...- mgrover2k2
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Selection criteria to exclude the last record for a group/day
Using:CR 9 , SQL Server I'm grouping on "type" and "date_time" (by day) and then Sum the "count" for each group. Type count date_time 1042 2 12/19/2003 11:50:31 PM 1042 2 12/19/2003 11:58:31 PM 1042 4 12/19/2003 11:59:31 PM 1042 3 12/20/2003 12:15:00 AM 1042 4...- mgrover2k2
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 1 Formulas
