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.

Taidot: Microsoft Access, Visual Basic

Näytä lisää: 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

Tietoa työnantajasta:
( 8 arvostelua ) tracy, United States

Projektin tunnus: #2587110

Myönnetty käyttäjälle:


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

$15 USD / tunti
(1 arvostelu)

9 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_18% %project_currencyDetails_sign_sub_19%/tunti tähän työhön


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

$15 USD / tunti
(21 arvostelua)

Dear Sir, I'm expert on access.

$15 USD / tunti
(43 arvostelua)

have a glance at PM. regards, shmai

$25 USD / tunti
(15 arvostelua)

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

$15 USD / tunti
(5 arvostelua)

Hello, I can help.

$25 USD / tunti
(1 arvostelu)

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

$85 USD / tunti
(0 arvostelua)

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

$20 USD / tunti
(0 arvostelua)

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

$20 USD / tunti
(0 arvostelua)