By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 1,910 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 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

✓ answered by Rabbit

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.

Share this Question
Share on Google+
4 Replies


Rabbit
Expert Mod 10K+
P: 12,315
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

Rabbit
Expert Mod 10K+
P: 12,315
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

Post your reply

Sign in to post your reply or Sign up for a free account.