Join Problem

[pgalvezt]

Hello, Im going to try to explain my model: I have many tables with two keys Periodo and CodComer. Each table has Different period names and cod comer Names so I have had that join them (Union Table) Everything works fine but when I do clic over castigos my pivot doesn't show anything. I attached my modelo with reducting data. If you need more information please let me know.

Thanks!

[pgalvezt]

Its the excel format. But 2 months gives wrong data. Periodo appears like Ene 2011. meanwhile Periodo_castigo Appears like 40285

I Left MonthName(Date(FECHA -1,'MMM-YYYY')) as Periodo_Castigo But Doesn't work.

Any Ideas?

[tanelry]

It is @Id field that causes the problem. I gave you solution in my last post. Revise all AutoNumber() instances in your script accordingly.

[pgalvezt]

Thank you but doesn't work finally I had to edit the excel file.

Thank you all of you!