Multiple Records in One Row - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Multiple Records in One Row

David Czerwinski

4 years ago

I have a table with customers and a table with multiple customer records. Say customer A has two records that I would like to list on one line. when I build a query or report I get 1 record per line.I think this is what I need (=ConcatRelated) but just cant seem to get it right. Im just learning VBA and could really use some help.
Dave CZ

	Scott Axton @Reply 4 years ago
Please post a mock up of what you're trying to do. What do you mean two records on one line? Also, if you could give us a screenshot of what you have now that would help.

	Alex Hedley @Reply 4 years ago
Could you not just use a Continuous Forms

	Alex Hedley @Reply 4 years ago
@Rick have you ever used ConcatRelated from Allen Browne, June 2008

	David Czerwinski OP @Reply 4 years ago

	David Czerwinski OP @Reply 4 years ago

	David Czerwinski OP @Reply 4 years ago
the report image was from a report I ran when all the record fields were in the same table as the techs but when I moved the records to there own table my query is one record per line instead of multiple records from the same tech

	Richard Rost @Reply 4 years ago
Alex, no, but that looks like my DLookupPlus function.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View