Tombstone08
New member
- Local time
- Today, 09:06
- Joined
- Dec 10, 2012
- Messages
- 4
Hi, I'm in need of some advise. I am a new Access 2010 user. A Query I have created produces a table of results, I need to export these to a csv file for importing elsewhere. I cannot figure out how to do this AND generate a single csv line for each result;
my query generates:
make,Ford;type,car;model,200;kit_component,kit1
make,Ford;type,car;model,200;kit_component,kit2
make,Ford;type,car;model,200;kit_component,kit3
make,Ford;type,car;model,200;kit_component,kit4
make,Ford;type,car;model,225;kit_component,kit71
make,Ford;type,car;model,225;kit_component,kit72
make,Ford;type,car;model,225;kit_component,kit73
make,Ford;type,car;model,225;kit_component,kit74
However
I need the output to be a single row, when a new row is created if there are any changes to values for "make" or "type" or "model" - laid out like this:
make,Ford;type,car;model,200;kit_component,kit1,kit2,kit3,kit4
make,Ford;type,car;model,225;kit_component,kit71,kit72,kit73,kit74
Can anyone offer me a solution . . . please
my query generates:
make,Ford;type,car;model,200;kit_component,kit1
make,Ford;type,car;model,200;kit_component,kit2
make,Ford;type,car;model,200;kit_component,kit3
make,Ford;type,car;model,200;kit_component,kit4
make,Ford;type,car;model,225;kit_component,kit71
make,Ford;type,car;model,225;kit_component,kit72
make,Ford;type,car;model,225;kit_component,kit73
make,Ford;type,car;model,225;kit_component,kit74
However
I need the output to be a single row, when a new row is created if there are any changes to values for "make" or "type" or "model" - laid out like this:
make,Ford;type,car;model,200;kit_component,kit1,kit2,kit3,kit4
make,Ford;type,car;model,225;kit_component,kit71,kit72,kit73,kit74
Can anyone offer me a solution . . . please