Em Andamento

VBA Excel And Access Integration

This is a fairly simple project. We have an Access Database which stores Phone call details. Each record in the table CallData is a call. There is a field called Hunt Group, which specifies the group to which the extension dialed belongs (this is a numeric value). We need to extract data meeting criteria: show the total number of calls for specified date rage (Start Date, End Date) for Hunt group where Complete(this is a field in the database) is equal to 1. (Have to do a group by and a count function along with Having clause). There a 79 Hunt groups in all but we want data only for 69 hunt groups. This is a static value. For the end result, this data is suppose to be presented in excel. There is a specified format, which is provided. What I want done is to program a button in Excel where it will create a connection to Access, Pass the parameters for the query (start date, end date), and then place the retrieved data in the right place. Require assistance with the query as well. Right now the way query is written if there are no calls for a particular Hunt Group for which reporting is required then in the query result that particular Hunt Group is omitted instead of giving a count of zero. No more than two users will be using this. The location of the database is static (it maybe nice to have a prompt for the locatoin of the database).

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.

3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).

## Platform

Office 2000

Habilidades: Engenharia, Excel, Microsoft Access, Microsoft Exchange, MySQL, PHP, Powerpoint, Arquitetura de software, Teste de Software, Visual Basic, Word

Ver mais: vba work, vba with, access group, vba right, value stores, right vba, end vba, visual basic form excel, vba access excel, office vba, hunt, excel function, excel vba, database required excel, project database vba excel, data integration excel, bid vba project, excel database visual basic, excel access table, access query table, access vba program, access query excel, create simple access database, vba function, excel count

Acerca do Empregador:
( 3 comentários ) United States

ID do Projeto: #3026607

Premiar a:

icodeinvb

See private message.

$34 USD em 2 dias
(316 Avaliações)
7.1

8 freelancers estão ofertando em média $27 para este trabalho

justserg

See private message.

$11.9 USD in 2 dias
(143 Comentários)
6.8
prasanna123

See private message.

$34 USD in 2 dias
(58 Comentários)
5.1
ericjiangvw

See private message.

$34 USD in 2 dias
(14 Comentários)
3.6
odysseyvw

See private message.

$34 USD in 2 dias
(32 Comentários)
3.3
vprovw

See private message.

$21.25 USD in 2 dias
(6 Comentários)
3.2
tzunivw

See private message.

$25.5 USD in 2 dias
(26 Comentários)
2.9
petrmarek

See private message.

$23.8 USD in 2 dias
(0 Comentários)
0.0