434,587 Members | 1,076 Online
Need help? Post your question and get tips & solutions from a community of 434,587 IT Pros & Developers. It's quick & easy.

# Using query results in an existing report

 P: 25 I have two tables that are not linked, one contains historical data related to the number of customers in a particular month while the other table contains staffing information and needs based on customer volume in a particular day. I'm trying to project the worked hours for employees based on customer volume. My table for annual customer data contains the month/year, number of customers, number of days in the month, and the avg customers per day. The second table contains daily required staffing loads and has many fields for each type of employee needed during the day. I know that my formula for calculating the field is the sum of all of the employees used at a particular time of day multiplied by 2080 (totals hours worked in a year) divided by the average annual customer volume multipled by the days in the year: (Annualized employees per hour * 2080)/(total annual customers * 365) My question is how do I use the values from the annual visits table when there's no logical link to the staff distribution? I also have a query that calculates the sum of customers annually, but how do I use that result in an existing report based on the staff distribution? Nov 9 '12 #1

I have trouble understanding your formula, some sample data would go a long way.

As for your second question, we normally only allow one question per thread. But that's an easy one so I'll let it slide. You can use one of the domain aggregate functions. Either DSum(), DCount(), DLookup, etc. If you need more help than that, please create a new thread for it.

4 Replies

 Expert Mod 10K+ P: 12,365 I have trouble understanding your formula, some sample data would go a long way. As for your second question, we normally only allow one question per thread. But that's an easy one so I'll let it slide. You can use one of the domain aggregate functions. Either DSum(), DCount(), DLookup, etc. If you need more help than that, please create a new thread for it. Nov 9 '12 #2

 P: 25 The second question was an option I was trying to get the first section to work. I tried the DSum() option and it worked beautifully! Thanks for your assistance Rabbit, you're a genius! Nov 9 '12 #3

 Expert Mod 10K+ P: 12,365 Glad you got it working, good luck with the rest of your project! Nov 9 '12 #4

 P: 25 Thanks . . . it's a very ambitious scheduling tool, so I'm sure you'll be seeing me here again soon! Nov 9 '12 #5