Find Jobs
Hire Freelancers

Data Sort and Export to Excel for reporting.

$30-100 USD

Fechado
Publicado há mais de 18 anos

$30-100 USD

Pago na 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 do Projeto: 26024

Sobre o projeto

29 propostas
Projeto remoto
Ativo há 17 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos

Sobre o cliente

Bandeira do(a) UNITED STATES
Philly, United States
0,0
0
Membro desde set. 7, 2005

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos 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)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.