Search results

Is there anyway I can be able to get the average? I have mentioned before that I want the average, not total sums.

Hey all, I have posted a problem 6 days and I still haven't got any answer back. Open up the database faculty ---> click on faculty Details --> then page 294. On that form --> what I want to do when I choose agent name on the top, and select the dates, it will populate me with the average of...

Okay, but this will give me the subtotal though. What do I do next?

=IIf(Int(DateDiff("d",[Date],[End Date]))>1, sum([Average_wrap]),"Not working") Could i use this formula?

Thanks for the reply back. So what does the footer does. I have watched the youtube video about it and I put that on footer, but nothing worked before. Let me give it a try on this sample database.

You will double click on Faculty file ---> you will open up the Faculty Details form ---> you will go to page 294 ---> and there you can select the Name on top and the dates.. once you click on span of dates, I want it to display the average wrap. I have put this IIF Condition just now...

Hey all, The attachment is an exame. Once you open the attachment ---> open up the faculty details form ---> and then open up the page 294. In there, once you select a name, and then the dates it will give you the stats for that employee. I have made a query which it has one formula for Average...

Here try to use this one: what I want to do is when you select those dates, and the agent name, it will return me the average wrap for the span of those dates. For instance, when you choose Test as a name, and then choose dates from Dec 20- Dec 26, and it will return the average for those six days.

Here is the table. right now, it doesn't show the names, but i'm more concerned on how to to return the average.

Okay, give me 5 minutes, so I can rebuild a basic template.

The problem is I can't be able to post it because it has private employee information. I would have posted it though. As I have said before, I will need begin date and end date so I can be able to select the data between the span of those dates. After selecting those dates I would want it to...

But that does not return the average value between two dates. I want to create a subform when I click on begin date and choose the end date and be able to return average of those dates. I can't be able to select two dates with one date.

do i use the Dlookup under the control box of TEXTBOX?

Alright, I understand now. I have just changed them. what should i do now?

Also, how can the user select the date if I can't put it on the field.

If i can't choose the name as part of my field, is there anyway I can be able to select those dates, and return me the average?

Date and End dates are for the purpose that the user can select the Begin Date and End date to create the average of the stats that I have stored on the stats table. I have taken Average Wrap as an example to see how I can retrieve averages on subform. This is what I put inside the Textbox under...

Yes, I have already finished all the tutorials, and this is pretty expert question. So, I have a table named; Stats which it has all the variables for the employees. I have made a query based on that table that will give me the AGENT NAME, DATE, END DATE, AND AVERAGE WRAP, which I have already...

So, how do I choose the agent name under the query when I do the group by. It doesn't select the agent name.

Hey all, I was wondering if I could be able to use the average formula in forms. I have begin date, end date, agent name, and I would want to take the difference between those dates and returns me the average of calls. I was successfully able to return the difference dates, but I can't get the...