Em Andamento

Access table needs cleanup. Need to flag contradictory info.

I have a simple table that has more than one line for each client. I need to move all the relevant data onto the same line so there will be a finished table with 1 Client_ID, for each client, which I can use as the key to import back into my customer database. Also I need to flag Client_ID’s that contain contradictory data so this can be manually addressed before the final table cleanup.

Description of table:

Table has date, comment, Y or N, and blank fields. Rules should be like this. Mm/dd/yyyy is over written by 10/05/2003, and blank field is over written by comments. Also if there are 2 field to be merged that both have data I need to get a list of them in some form to be able to manually fix them. That’s it.

30 columns to repete this process with.

## Deliverables

1) Fully functional Access statement or query that will merge a 30 column table into manageable data (All data associated with one client in one line instead of 3 or 4 as it is now) and will list the Client_ID’s that have contradictory information.

2) Simple instructions how to implement this query within Access so I can do the actual cleanup of the data myself.

3) Agree to keep sample data private.

## Platform

I have MS Access in a windows environment, but am open to using another tool if available to complete this task.

Habilidades: PHP

Ver mais: table customer, open-table, customer table, query table, need to get, in process access, flag, cleanup, needs written, import access database php, access query table, fix database access, customer merge, blank fields, fix customer form, access table query, access merge table, access table query form, info line, access database process, import database access php, access client database, import access database php database, open table, import data access

Acerca do Empregador:
( 6 comentários ) United States

ID do Projeto: #3026026

Premiar a:

stevewvw

See private message.

$29.75 USD em 7 dias
(109 Avaliações)
5.9

17 freelancers estão ofertando em média $49 para este trabalho

justserg

See private message.

$12.75 USD in 7 dias
(143 Comentários)
6.8
sergruch

See private message.

$42.5 USD in 7 dias
(84 Comentários)
5.4
miguelgarcia78

See private message.

$34 USD in 7 dias
(79 Comentários)
5.2
peteoconnor

See private message.

$85 USD in 7 dias
(14 Comentários)
5.0
mayurshahvw

See private message.

$85 USD in 7 dias
(4 Comentários)
3.1
stolevw

See private message.

$6.8 USD in 7 dias
(28 Comentários)
2.6
olgakvw

See private message.

$5.1 USD in 7 dias
(6 Comentários)
1.9
anik5

See private message.

$72.25 USD in 7 dias
(2 Comentários)
1.8
jvmvw

See private message.

$21.25 USD in 7 dias
(3 Comentários)
1.3
vw386550vw

See private message.

$46.75 USD in 7 dias
(2 Comentários)
0.9
dotnetcodervw

See private message.

$85 USD in 7 dias
(0 Comentários)
0.0
puvakil

See private message.

$51 USD in 7 dias
(0 Comentários)
0.0
frankjuszli

See private message.

$68 USD in 7 dias
(0 Comentários)
1.4
nevermalchik

See private message.

$85 USD in 7 dias
(0 Comentários)
0.0
drbast

See private message.

$85 USD in 7 dias
(0 Comentários)
0.0
usulix

See private message.

$21.25 USD in 7 dias
(0 Comentários)
0.0