Search results for query: *

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...

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...

-LB Thank you for your response! It worked perfectly! You just saved me hours! Paul

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...

k- yes, these are the only timeframes. I tried grouping your formula, and the results showed: 3 xxxx 4 xxxx 5 xxxx I need: 9a-12p xxxx xxxxx 12p-3p xxxx xxxxx where "x" is only data from the specific time frame. Your formula had cross over. I have a thirty minute formula...

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!

You guys are great! Thanks so much for the help! Works great!

Thanks for the response. The issue is everything before the decimal. If I have 2.75, simply multiplying by 60 results in 165. How do I convert just the decimal without touching the hour?

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.

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...