In Progress

MS Access Query

Team Schedules. I have 2 tables - 1 with an agents daily schedule and 1 that reports the agents telephone time in a given state (phone, avail, on call, aux). Table 1 (Schedules) is in 15 minute intervals - Table 2 (Agent Time In State) reports their activity for the entire day by time.

I need to track what the agent was doing for each 15 minute interval during the day based on the Agent Time In State table. e.g. If the agent is scheduled to be on the phone from 8:00 - 8:15 and the Agent Time report has them taking calls (ACD) and not taking calls (AUX) - I need the query to return the amount of time that the agent was in each state during the interval. Each interval should add up to 15 minutes.

I can provide a sample to provide more detail.

Skills: Microsoft Access, Visual Basic

See more: schedule agent, n query, daily access, query table, access query table, access activity report, access table query, visual schedule, minute calls, access report sample, access daily, access activity, taking calls, report access, telephone agents, daily phone calls, telephone agent, agent access, time schedule table, time schedule access, return calls, access visual basic, access day, visual basic access table, query report access

About the Employer:
( 7 reviews ) tracy, United States

Project ID: #2587110

Awarded to:

boyet0911

Experiences programmer here with ample experience on systems development. Kindly check your pmb for my details. thanks!

$15 USD / hour
(1 Review)
1.5

9 freelancers are bidding on average $26/hour for this job

winnet21

Hi, I have experience with this project, I happily if work with you in this project. Regards

$15 USD / hour
(21 Reviews)
5.4
NourElDeen

Dear Sir, I'm expert on access.

$15 USD / hour
(43 Reviews)
5.2
shmai

have a glance at PM. regards, shmai

$25 USD / hour
(15 Reviews)
4.6
developer0106

Hi, I can do it for you quickly. Please check your private message for more details. Thank you.

$15 USD / hour
(5 Reviews)
3.2
AccuPro

Hello, I can help.

$25 USD / hour
(1 Review)
2.8
bsoist

I am ready to get started. Please see PM for clarification of my bid.

$85 USD / hour
(0 Reviews)
2.0
wawansetiyawan

please cek my portfolio, VB my experience... I'll do that!! PM me

$20 USD / hour
(0 Reviews)
0.0
shanki161

Hello Sir, I understand your requirement.We will use few formula and than it can be done.We are looking forward for your positive response. Thanks and Regards Karan

$20 USD / hour
(0 Reviews)
0.0