Find Jobs
Hire Freelancers

Data Sort and Export to Excel for reporting.

$30-100 USD

Cerrado
Publicado hace más de 18 años

$30-100 USD

Pagado a la entrega
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
ID del proyecto: 26024

Información sobre el proyecto

29 propuestas
Proyecto remoto
Activo hace 17 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos

Sobre este cliente

Bandera de UNITED STATES
Philly, United States
0,0
0
Miembro desde sept 7, 2005

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.