Need to return an array to display data vertically in a report

[Historypaul]

I need something like the dlookup function, but I need it to test for how many records there are that match the criteria and return the value in a field from multiple records or loop until it returns a null and display the same field from all records that match the criteria I give it. I've seen a lot of dlookup alternative custom functions out there. I just can't find this one in particular.

I have a parent table and a child table. I'm trying to create a report that shows the parent info and the child info all on one line for each parent record. The quantity of records in the child table that relate that particular record on the parent table varies.



Maybe more clearly, I'd like to return an array made up of the same field from multiple records that match the criteria...

[Historypaul]

I really wish I could change the "vertically" to "horizontally" in the title of this post... Sorry.

[orange]

see https://www.accessforums.net/queries/combine-multiple-records-into-single-record-10599.html

[Historypaul]

Thank you, Orange. I'll read that one. It gets a little in-depth. I've been working on the problem already, and I've ended up so far with a crosstab query, then a join query to put those results on a single line with related tables results. It's working pretty good so far.