List multiple fields in one field

[overworked]

I am trying to combined the data from multiple tables into one list in a query and everything that I have tried isn't giving me the result that I am looking for. I keep getting Err#, -1 or it merges all of data together.

I've tried Nz statements with an &...I get the data merged together
Tried Nz statements with +....I get Err#
IIf statements have gotten me a syntax error

The closest result to what I am looking for is "NapkinPlateForkSalad" in one line of the query. When I am really looking for is each item listed in it's own line, like:

Napkin
Plate
Fork
Salad

The data comes from different tables. Napkin comes from the disposable table, Plate and Fork come from the rental table, Salad comes from the meal table. I am trying to create a one list query for the report that will show everything for the one job.

I am trying to do this with a query, so I think it would be done in the espression builder.

Thank you for your help.

 

[Pat Hartman]

You should probably have one table rather than four but I don't have enough information to make a definitive statement. You could use a union query but I would probably add four subreports. One for each of the tables.

 

[overworked]

OMG, how stupid can I be. Of course a union query, why didn't I think of that. But subreports, now there is something I don't know about. I am going to have to research that.