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!

Register Log in
  • Congratulations dencom 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: Melmeg
  • Content: Threads
  • Order by date
  1. Melmeg

    Averaging Time (HH:MM:SS) excluding Records with a time of Zero

    Hello experts, I am trying to get an average time in hh:mm:ss without counting the records with a zero value. From the results below you see the total is actually an average of all the 14 records but I only need an average of the four records that have a time. One of the column is in seconds...
  2. Melmeg

    Something similar to a Manual Cross-Tab but not quite

    I'm trying to generate a report in Crystal Reports 2008 that gives me an overview of Users' results for a Month ignoring the date it was taken. For example the results table looks like this: User Name Result Date_taken User1 80 4/2/2011 User1 98 4/3/2011 User1 100 4/3/2011 User2 78 4/3/2011...

Part and Inventory Search

Back
Top