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

D

Darlene at Rb

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!
 
R

Rick Brandt

Darlene said:
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!
Click to expand...

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.
 
D

Darlene at Rb

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?
 
Top