Suoritettu

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:

boyet0911

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

$15 USD / tunti
(1 arvostelu)
1.5

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

winnet21

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

$15 USD / tunti
(21 arvostelua)
5.4
NourElDeen

Dear Sir, I'm expert on access.

$15 USD / tunti
(43 arvostelua)
5.2
shmai

have a glance at PM. regards, shmai

$25 USD / tunti
(15 arvostelua)
4.6
developer0106

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

$15 USD / tunti
(5 arvostelua)
3.2
AccuPro

Hello, I can help.

$25 USD / tunti
(1 arvostelu)
2.8
bsoist

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

$85 USD / tunti
(0 arvostelua)
2.0
wawansetiyawan

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

$20 USD / tunti
(0 arvostelua)
0.0
shanki161

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)
0.0