Find Jobs
Hire Freelancers

ASP crosstab report with date filter from MS Access query

$20-25 USD

Cancelled
Posted over 15 years ago

$20-25 USD

Paid on delivery
I have a MS Access DB with several fields but I am only looking to use 3 fields. The three fields are Associate, Category, and Date Entered. I want a cross tab report written in classic [login to view URL] the Associate names in the first row, then Each Category for the columns with a count of each category for each associate. I also want the report to have a date filter where a user can input a start and end date which will filter from the date entered field. I would also like to get a total of all items by both associate and then category. Last requirement I need is to have an export option to MS Excel file. I will try to illustrate below. Start date: End Date: Cat1. Cat2 Cat3 ..... Assoc. Total Associate 1 Associate 2 Associate 3 Cat1total Cat2 Total Cat3 Total All records total A few design request: Have Associate list and Category names in bold Have associate list rows have alterenating color (white/light grey) Have Totals on side and bottom have gold background. * Once approved I will forward the Access DB. * Having something similar I can view will help with my choosing a coder. * Report must be written in classic ASP. I am running Server 2003 with IIS 6.0. I will do the final installation of report on our web server. I will also note the db location in association with the report when developing the report.
Project ID: 3130647

About the project

2 proposals
Remote project
Active 16 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
2 freelancers are bidding on average $21 USD for this job
User Avatar
See private message.
$21.25 USD in 5 days
3.9 (11 reviews)
3.5
3.5
User Avatar
See private message.
$21.25 USD in 5 days
4.4 (6 reviews)
2.5
2.5

About the client

Flag of UNITED STATES
United States
5.0
32
Member since Jul 27, 2005

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.