In Access, how do I repeat one field, but not all fields?

[Guest]

I work for a residential home builder. I have a query that pulls notes
regarding homes. I have another query that combines these notes with the
details of each home--project, unit, plan, address, homeowner (if any), etc.

I would like the results to display all of the fields regarding the home
information only one time but repeat the notes field for all existing notes.
Something like....
PROJECT UNIT PLAN ADDRESS HOMEOWNER NOTES
NOTES
NOTES

OR, combine all notes into one field for the home. Something like...
PROJECT UNIT PLAN ADDRESS HOMEOWNER NOTES; NOTES; NOTES;

Thank you for your assistance!

 

[Rick Brandt]

I work for a residential home builder. I have a query that pulls
notes regarding homes. I have another query that combines these
notes with the details of each home--project, unit, plan, address,
homeowner (if any), etc.

I would like the results to display all of the fields regarding the
home information only one time but repeat the notes field for all
existing notes. Something like....
PROJECT UNIT PLAN ADDRESS HOMEOWNER NOTES


NOTES NOTES

OR, combine all notes into one field for the home. Something like...
PROJECT UNIT PLAN ADDRESS HOMEOWNER NOTES; NOTES; NOTES;

Thank you for your assistance!

You can do this in a report, not in a query. Controls in a report have a
"Hide Duplicates" property or you can accomplish the same thing by setting
up group sections in the report.

 

[Guest]

Thank you Rick. Right now I have imported the query into Excel. Is there a
way to do this in Excel? Or, should I begin by creating a report in Access
utilizing this query?

 

[Rick Brandt]

Thank you Rick. Right now I have imported the query into Excel. Is
there a way to do this in Excel? Or, should I begin by creating a
report in Access utilizing this query?

If you build a report that is fairly "tabular" looking it should export to
Excel. There are certain labels and calculated controls that won't be
included in the export though.

 

[Duane Hookom]

There is a generic concatenate() function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. This
function can be used to display all the notes in a single expression.