Recent content by chivo123

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.