Including multiple queries in a report?

[sailorguy]

Hello there,

Still learning so please be nice

I want to create a simple report based on 4 queries I have. The queries all work fine, and show me unused DN, TN, DID, Phantom numbers from their respective tables (2 columns each the "number" and the "numberID").

I can create a report simply from each query, but I want to basically have the columns from each query all on the same report. If I try to add the fields from each query in the report wizard i get an error "You have chosen fields from record sources which the wizard can't connect...."

Is there a proper way to do this?

 

[SOS]

subreports - (one for each query)

 

[sailorguy]

Oh, thanks I didn't realize that. Worked easily! Thanks