Export to Excel a linked 1:Many Table

  • Thread starter Thread starter Sidney
  • Start date Start date
S

Sidney

Hi

I have an Access 07 database to track Issues. I have 1 table that has the
basic Issues information (tblIssues). Linked to this is another table
(tblNotes) that allows users to enter multiple notes for each issue as
progress is being made. In the tblNotes, I have 3 key fields that I need to
export: NoteEnteredBy, NoteDate, and the Note.

I am trying to export the tblIssue to Excel with all of the associated
notes. I have no trouble exporting the tblIssue - I just can't figure out
how to also export the associated Notes. Ideally, I would like the Notes
cell in Excel to be concatenated with the date, author, and note. For
example, below is an outline of what I would like to see:

Header Row: IssueID IssueTitle IssuePriority Notes
Data: 1 Test High [date -
Sid] This is note 1.

[date - Jane] This is note 2.

I hope this makes sense. Does anybody have any code that can do this? I am
currently using the TransferSpreadsheet to export the tblIssues.

Thanks
Sidney
 
Sidney,
here is a link to a sample database that will join up (concatenate) the
notes for each issue.


Jeanette Cunningham -- Melbourne Victoria Australia


Sidney said:
Hi

I have an Access 07 database to track Issues. I have 1 table that has the
basic Issues information (tblIssues). Linked to this is another table
(tblNotes) that allows users to enter multiple notes for each issue as
progress is being made. In the tblNotes, I have 3 key fields that I need
to
export: NoteEnteredBy, NoteDate, and the Note.
Click to expand...
I am trying to export the tblIssue to Excel with all of the associated
notes. I have no trouble exporting the tblIssue - I just can't figure out
how to also export the associated Notes. Ideally, I would like the Notes
cell in Excel to be concatenated with the date, author, and note. For
example, below is an outline of what I would like to see:

Header Row: IssueID IssueTitle IssuePriority Notes
Data: 1 Test High
[date -
Sid] This is note 1.

[date - Jane] This is note 2.

I hope this makes sense. Does anybody have any code that can do this? I
am
currently using the TransferSpreadsheet to export the tblIssues.

Thanks
Sidney
Click to expand...
 
You could export a query that joins the tables and includes the fields you
need. You can even use a calculated control to concatenate the fields from
the notes table.
 
Hi Jeanette

Thanks for the reply. I did not find a link though to the sample database.
Could you please resend?

Thanks
Sidney

Jeanette Cunningham said:
Sidney,
here is a link to a sample database that will join up (concatenate) the
notes for each issue.


Jeanette Cunningham -- Melbourne Victoria Australia


Sidney said:
Hi

I have an Access 07 database to track Issues. I have 1 table that has the
basic Issues information (tblIssues). Linked to this is another table
(tblNotes) that allows users to enter multiple notes for each issue as
progress is being made. In the tblNotes, I have 3 key fields that I need
to
export: NoteEnteredBy, NoteDate, and the Note.
Click to expand...
I am trying to export the tblIssue to Excel with all of the associated
notes. I have no trouble exporting the tblIssue - I just can't figure out
how to also export the associated Notes. Ideally, I would like the Notes
cell in Excel to be concatenated with the date, author, and note. For
example, below is an outline of what I would like to see:

Header Row: IssueID IssueTitle IssuePriority Notes
Data: 1 Test High
[date -
Sid] This is note 1.

[date - Jane] This is note 2.

I hope this makes sense. Does anybody have any code that can do this? I
am
currently using the TransferSpreadsheet to export the tblIssues.

Thanks
Sidney
Click to expand...
Click to expand...
 
Sidney here is the link - sorry it didn't paste into the last reply.

http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'


Jeanette Cunningham -- Melbourne Victoria Australia


Sidney said:
Hi Jeanette

Thanks for the reply. I did not find a link though to the sample
database.
Could you please resend?

Thanks
Sidney

Jeanette Cunningham said:
Sidney,
here is a link to a sample database that will join up (concatenate) the
notes for each issue.


Jeanette Cunningham -- Melbourne Victoria Australia


Sidney said:
Hi

I have an Access 07 database to track Issues. I have 1 table that has
the
basic Issues information (tblIssues). Linked to this is another table
(tblNotes) that allows users to enter multiple notes for each issue as
progress is being made. In the tblNotes, I have 3 key fields that I
need
to
export: NoteEnteredBy, NoteDate, and the Note.
Click to expand...
I am trying to export the tblIssue to Excel with all of the associated
notes. I have no trouble exporting the tblIssue - I just can't figure
out
how to also export the associated Notes. Ideally, I would like the
Notes
cell in Excel to be concatenated with the date, author, and note. For
example, below is an outline of what I would like to see:

Header Row: IssueID IssueTitle IssuePriority Notes
Data: 1 Test High
[date -
Sid] This is note 1.

[date - Jane] This is note 2.

I hope this makes sense. Does anybody have any code that can do this?
I
am
currently using the TransferSpreadsheet to export the tblIssues.

Thanks
Sidney
Click to expand...
Click to expand...
Click to expand...
 
Back
Top