How do I get a query to appear within a report?

[rebfein]

My boss now wants a query to appear within a report. I have the report set up:




This data changes, depending on the model entered in the form, and can be just a few lines as shown lines here or up to 18 lines.

The form:


The data:


The query:


He wants the information to appear like this:


In the report design, I've tried to enter the query as a sub-form or as a list box. In either case, no information appears. I mean it is blank.

Any step-by-step instructions?

[June7]

You seem to have done appropriate steps to display the data. If you want to provide db for analysis, follow instructions at bottom of my post.

[orange]

I recommend you review this material by Martin Green Dynamic Reports