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, what is ms 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, visual access ms access, time schedule table, time schedule ms access, return calls, ms access visual basic, ms access schedule

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

Project ID: #2587110

Awarded to:


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

$15 USD / hour
(1 Review)

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


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

$15 USD / hour
(21 Reviews)

Dear Sir, I'm expert on access.

$15 USD / hour
(43 Reviews)

have a glance at PM. regards, shmai

$25 USD / hour
(15 Reviews)

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

$15 USD / hour
(5 Reviews)

Hello, I can help.

$25 USD / hour
(1 Review)

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

$85 USD / hour
(0 Reviews)

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

$20 USD / hour
(0 Reviews)

Hello Sir, I understand your [url removed, login to view] will use few formula and than it can be [url removed, login to view] are looking forward for your positive response. Thanks and Regards Karan

$20 USD / hour
(0 Reviews)