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: paulpeyton
  • Content: Threads
  • Order by date
  1. paulpeyton

    ACCESS 97 AVERAGES

    I have a report in Access 97 I am trying to build. The report is for classroom surveys. I have the averages for each question across the survey. What I need is one average across all questions (class average) and an average for sets of questions on the survey:Q1-Q3, Q4-Q9, etc. I am having...
  2. paulpeyton

    Static percentage formula (EXCEL)

    How do I write a formula (or is there some other way) to take a static percentage, say 10%, and calculate the number of times that percentage can be taken of a number to ultimately reach a particular threshold. EX. 10% of 10 is 1 10-1 is 9 10% of 9 is .9 9-.9 is 8.1 10% of 8.1 is ..... to...
  3. paulpeyton

    Most recent DateTime

    I am trying to determine and display the most recent DateTime for a series of calls over a specific timeframe. In other words, we may call a customer five times a day for a period of five days. I only want to display the most recent calling day and the last call time attempted. I currently...
  4. paulpeyton

    Another Time Segment problem!

    You guys have always been great in a pinch! Thanks in advance! I need to group data off of an event date-time field in 3 hour segments. ex. 9a-12p, 12p-3p, 3p-6p, and 6p-9p. I don't know how to write the formula. Any help is greatly appreciated!
  5. paulpeyton

    Convert numerical value to time value

    I have fields that contain a figure in seconds. I then divide that by 3600 to get hours, but I may get 2.75 hours. How do I convert the .75 to read .45 (minutes)? This issue is throwing off other calculations in my reports. Any assistance will be greatly appreciated.
  6. paulpeyton

    Sum of Distinct Count

    I have a report grouped by day, and by thirty minute segments of that day. The report returns a distinct count of the number of associates available to work each half-hour period. The issue I have is that I cannot figure a way to total (or average) the number of associates available the entire...

Part and Inventory Search

Back
Top