Data Sort and Export to Excel for reporting.
$30-100 USD
Dibayar semasa penghantaran
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][url removed, login to view] 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][url removed, login to view] 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][url removed, login to view] 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][url removed, login to view] 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][url removed, login to view] 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][url removed, login to view] 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][url removed, login to view] 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][url removed, login to view] 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][url removed, login to view] 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][url removed, login to view] 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][url removed, login to view] 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][url removed, login to view] 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][url removed, login to view] 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][url removed, login to view] 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][url removed, login to view] 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][url removed, login to view] 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][url removed, login to view] 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][url removed, login to view] 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][url removed, login to view] 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][url removed, login to view] 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][url removed, login to view] 90210-22973 packing 33 2005-9-7-104162 2005-9-7 2005-9-7104123-41 NA NA No
ID Projek: #26024
