when i'm trying to create pivot table from table or query, access just shut down.
I used to create pivot on access before, but this time... it keeps shutting down even i'm trying to create new db, it always happens.
I tried to export query text file for SAP by having new record continue to previous one without going to new line.
This is my current result..
0001|John|4/5 Telecommunication com.
0002|Henry|3 Rama2
0003|Paul|2 Siemenset com.
This is what I want it to be
0001|John|4/5 Telecommunication...