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!

Recent content by Luca5h

  1. Luca5h

    Group By Date Range Parameter

    Hi Dlee, Thanks for the quick response. I originally tried grouping by creationdate, but as in your case, there are records that have a closeddate within the date range, but have creationdates outside the range, so grouping by creationdate results in rows well outside my range. I'll keep...
  2. Luca5h

    Group By Date Range Parameter

    Sorry, forgot to mention, i'm using CRXI with SQL2000. Thanks, Lucas
  3. Luca5h

    Group By Date Range Parameter

    Hi DLee, I need a report almost exactly the same as yours, but am having some problems. My table ([TICKET]) has [creationdate] and [closeddate] fields, and i can use isnull(closeddate) to differentiate between 'open' and 'closed' records. I already had the following selection formula in...

Part and Inventory Search

Back
Top