Export to Excel And Merge Fields

derekbrown

Registered User.
Local time
Today, 00:03
Joined
Jun 8, 2005
Messages
12
Hello folks

I am developing a basic Fault Logging system so I have a main form that allows ref to be input, date fault raised, priority, etc... I also have a sub form running that allows notes to be input. There is no set limit on the number of notes that can be added as this needs to be flexible. A relationship is set up so that the Fault reference will be tagged to each of the notes. What I need is a query (I'm guessing that is the best way to do it) that will gather all of the standard fields fromthe main form and also all of the note fields (it will need to return null values in notes fields). Preferably I would like all of the notes fields to concatenate into one field with a line break between each note. The concatenation process would have to be flexible and dynamic as there is no predetermined limit to the number of notes that will have to be joined together.

I'm relatively new to Access and having searched the forums and tried a few ideas can't find anything that I can adapt to my situation. Any ideas/guidance would be greatly appreciated!

Thanks!
 
What you describe is an absolute doddle in an Access report. Why does Excel have to get involved?
 
Excel needs to be involved because...

The entries have to be exported into a spreadsheet to be sent to an external company. The database part is an internal tracking tool that will log more than just faults. Therefore it is not viable to expose the database to any of the external companies. So, hopefully, if it's easy to write the report someone should be able to help me with the excel part? :)
 
It's not easy to do what you ask. By using Excel you are introducing an extra complication.

Any report in Acces can by exported as a snapshot file which can be read by anyone with Access installed or with Snapshot Viewer. This does not involve sharing the database.

If you want to export to Excel, this involves exporting records. Because Excel deals with flat files, it can't cope with the multiple notes situation. It is possible to concatenate the results of a one to many relationship and I think I've seen this talked about on here, but I seem to think it still involves a report.
 

Users who are viewing this thread

Back
Top Bottom