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

Veja mais: vba work, vba with, access group, what is vba in excel, what is vba, vba right, value stores, right vba, end vba, visual basic form excel, vba excel, vba access excel, project on vba, office vba, hunt, excel vba form & data work, Excel to Access, excel function, Excel and VBA, database required in excel, database in excel format, ACCESS VBA, project database vba excel, data integration excel, bid vba project

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

ID do Projeto: #3026607

Concedido a:


See private message.

$34 USD em 2 dias
(316 Comentários)

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


See private message.

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

See private message.

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

See private message.

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

See private message.

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

See private message.

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

See private message.

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

See private message.

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