Grabbing more than one related value

[wingforward]

This is a simplification of my problem, but if I can get an answer to this I think I'll be good to go.

I have a table of Memberships and one-to-many relation to a child table, MembershipCodes. There's 0-3 children for each parent. I need to export and/or build a report that shows each Membership and all its MembershipCode children in separate columns in one row.

DLookup() pulls only the first. I'd like to pull the first, and then the second and then the third. I'm open to SQL suggestions too.

Thanks,
DJ

 

[boblarson]

How about checking this function out from Access MVP Allen Browne.

 

[wingforward]

That's close. I really want the values as separate columns for export. Basically converting a relational to a flat file with a max of 3 rows.

I suppose I can use that and use a special delimiter and load the values into separate columns.

But if I just wanted to pull a single value, say the first or the second or the third of related child records, anyone know a custom function for that?