Find Jobs
Hire Freelancers

Data Sort and Export to Excel for reporting.

$30-100 USD

Closed
Posted over 18 years ago

$30-100 USD

Paid on delivery
Using the sample data provided, create an ms access database then use visual basic 6, ADO coded recordset (no data controls please), MS Excel. Export the tables in a logically formatted fashion to an Excel spreadsheet. The sample data will change frequently, the table and columns will always be the same though. All I need is the sorting (ordertotal) from largest to smallest, another page in the spreadsheet with smallest to largest, export that data to excel, save the file in the same directory (application path). This should be a simple project for a good coder who has worked with Excel objects and Acess tables in VB before. Please include what tools you will use to accomplish this work, your exact timeline, and a solid price in your bid. Incomplete bids or redirection to a message elsewhere will miss out. (Sorry for not including the msAccess file. My connection will not allow a file upload from here.) Good luck and happy bidding coders! Sample data: COLUMNS: ID fname lname phone email pcode orderstatus ordertotal orderdate shipdate orderID comments orderdetails followupdone DATA: 1 test test 555-123-1239 test[at][login to view URL] 90210-22973 packing 734 2005-9-7-104123 2005-9-7 2005-9-7104123-1 NA NA No 2 test test 555-123-1239 test[at][login to view URL] 90210-22973 packing 236 2005-9-7-104104 2005-9-7 2005-9-7104123-2 NA NA No 3 test test 555-123-1239 test[at][login to view URL] 90210-22973 packing 654 2005-9-7-104108 2005-9-7 2005-9-7104123-3 NA NA Yes 4 test test 555-123-1239 test[at][login to view URL] 90210-22973 packing 356 2005-9-7-104109 2005-9-7 2005-9-7104123-4 NA NA No 5 test test 555-123-1239 test[at][login to view URL] 90210-22973 packing 554 2005-9-7-104110 2005-9-7 2005-9-7104123-5 NA NA No 6 test test 555-123-1239 test[at][login to view URL] 90210-22973 packing 23 2005-9-7-104111 2005-9-7 2005-9-7104123-6 NA NA No 7 test test 555-123-1239 test[at][login to view URL] 90210-22973 packing 113 2005-9-7-104155 2005-9-7 2005-9-7104123-7 NA NA Yes 8 test test 555-123-1239 test[at][login to view URL] 90210-22973 packing 335 2005-9-7-104114 2005-9-7 2005-9-7104123-8 NA NA No 9 test test 555-123-1239 test[at][login to view URL] 90210-22973 packing 667 2005-9-7-104124 2005-9-7 2005-9-7104123-9 NA NA No 10 test test 555-123-1239 test[at][login to view URL] 90210-22973 packing 334 2005-9-7-104125 2005-9-7 2005-9-7104123-12 NA NA No 11 test test 555-123-1239 test[at][login to view URL] 90210-22973 packing 11 2005-9-7-104126 2005-9-7 2005-9-7104123-34 NA NA No 12 test test 555-123-1239 test[at][login to view URL] 90210-22973 packing 13 2005-9-7-104127 2005-9-7 2005-9-7104123-35 NA NA No 13 test test 555-123-1239 test[at][login to view URL] 90210-22973 packing 42 2005-9-7-104128 2005-9-7 2005-9-7104123-36 NA NA Yes 14 test test 555-123-1239 test[at][login to view URL] 90210-22973 packing 42 2005-9-7-104131 2005-9-7 2005-9-7104123-37 NA NA Yes 15 test test 555-123-1239 test[at][login to view URL] 90210-22973 packing 42 2005-9-7-104132 2005-9-7 2005-9-7104123-25 NA NA Yes 16 test test 555-123-1239 test[at][login to view URL] 90210-22973 packing 42 2005-9-7-104133 2005-9-7 2005-9-7104123-22 NA NA No 17 test test 555-123-1239 test[at][login to view URL] 90210-22973 packing 42 2005-9-7-104134 2005-9-7 2005-9-7104123-53 NA NA No 18 test test 555-123-1239 test[at][login to view URL] 90210-22973 packing 612 2005-9-7-104145 2005-9-7 2005-9-7104123-46 NA NA No 19 test test 555-123-1239 test[at][login to view URL] 90210-22973 packing 1174 2005-9-7-104156 2005-9-7 2005-9-7104123-43 NA NA No 20 test test 555-123-1239 test[at][login to view URL] 90210-22973 packing 45 2005-9-7-104167 2005-9-7 2005-9-7104123-77 NA NA No 21 test test 555-123-1239 test[at][login to view URL] 90210-22973 packing 33 2005-9-7-104162 2005-9-7 2005-9-7104123-41 NA NA No
Project ID: 26024

About the project

29 proposals
Remote project
Active 17 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

About the client

Flag of UNITED STATES
Philly, United States
0.0
0
Member since Sep 7, 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.