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