Hi, looking for some help in creating a report (which needs to be in a specific format). I need to create an excel file containing fields and values from a report i have created in microssoft access 2000.
The fields are something like this:
field1, field2 Field5
field3(in detail), field4(in detail)
Fields 3 and 4 are in detail while the other fields are in a header, the detail here will be duplicated several times per header.
When i export this using 'Output to' into an excel file fields 3 and 4 are formated to the end of the file, giving us something like this:
Field1, field2, field5
field3, field4
I have looked at format on the 'Output to', but does not seem to work for excel files.
Any ideas, suggestions?
Thnx in advance
The fields are something like this:
field1, field2 Field5
field3(in detail), field4(in detail)
Fields 3 and 4 are in detail while the other fields are in a header, the detail here will be duplicated several times per header.
When i export this using 'Output to' into an excel file fields 3 and 4 are formated to the end of the file, giving us something like this:
Field1, field2, field5
field3, field4
I have looked at format on the 'Output to', but does not seem to work for excel files.
Any ideas, suggestions?
Thnx in advance
