Recent content by msquery

Thank you so much! The formula did work. Currently, I have it set up as two queries one for all the sums and one for the records. How can I bring both together on one report? When I try to add the ASA on the TSA query it says I can't do a subquery. Both are expressions. What do I need to do to...

Query Only no SQL Statements With this query, I did not use SQL. I wanted to keep it simple for now. How would I do it without using SQL statements.

I am trying to get the Total average speed answered (ASA) based on two columns sums. (i.e. sum of calls handled and sum total speed answer). I need to get the total avg speed ans (formula is sum of total speed answer (tsa) divided by sum calls handled). I did an average query for asa but it...

Please Help. I am tring to get the Month to date, year to date and week to date total in a query. I added a parameter for a date range. Instead of giving me the mtd, wtd, ytd, I get the whole months daily total. Can someone tell me what query caculation do I need to just get one number instead...

I was not able to get the totals with the formulas given. I received the totals for each day instead. Are there any other suggestions? I am trying to different formulas, but they are not working either. I did try doing different queries with the formulas to see if that would work.

Can someone tell me how to get year to date totals, month to date totals, week to dates in a query? I need to get all three for three different fields. I was not able to get the totals with the formulas given. I received the totals for each day instead. Are there any other suggestions? I am...