Access will not export as dbf file due to duplicate fields? 1

[netrusher]

The code below is a query that I have from two tables downloaded from another application. I am trying
to export this query as a dbf file and keep getting the following error:

Cannot define field more than once

I have purposefully renamed each field in the two tables and I cannot find a field with the same name
so I do not understand why I cannot export this as a dbf file. Can anyone help?

SELECT L177TIME.TPROCESS, L177TIME.TOPERATION_, L177TIME.TSOE_CODE, 
L177TIME.TEVENT_NUMB, L177TIME.TEVENT, L177TIME.TEVENT_TIME, L177TIME.TTimeProduct, 
L177TIME.TTimeProductDesc, L177MATL.ParentM, L177MATL.ParentDescM, L177MATL.ChildM, 
L177MATL.ChildDescM
FROM L177TIME LEFT JOIN L177MATL ON (L177TIME.TEVENT_NUMB = L177MATL.EVENT_NUMBM) 
AND (L177TIME.TBUILD_ID = L177MATL.BUILD_IDM) AND (L177TIME.TPROCESS = L177MATL.PROCESSM) 
AND (L177TIME.TSEQUENCE_N = L177MATL.SEQUENCE_NM) AND (L177TIME.TSOE_CODE = L177MATL.SOE_CODEM)
WHERE (((L177TIME.TPROCESS) In ("7/010drivetrain","7/011wet axle prep","7/020brake pedal","7/030throttle
pedal","7/040valve assy","7/050manual levers","7/060cowl assy","7/070 display","7/080dsl sender","7/090ohg 
dress","7/095tilt sub assy","7/100frame dress","7/110steeraxle dress","7/120d'axle to 
trans","7/130mainline","7/150radiator build","7/160throttle crank","7/170battery box","7/180fuel 
systems","7/190air filter assy","7/200hood assy","7/220functional test","7/225cwt prep","7/230cwt 
hang","7/230lpg tray sub","7/240tray fit","7/2421lcv build","7/2423chain sth sub")))
ORDER BY L177TIME.TPROCESS, L177TIME.TOPERATION_, L177TIME.TSOE_CODE, L177TIME.TEVENT_NUMB;

 

[dhookom]

I believe DBF supports only 8 characters for a field name. Your names are probably being truncated which causes duplicates of at least "TTimePro".

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[netrusher]

Dhookom,

That did the trick! Thanks for your help.