Multiple Queries on One Report (Not a dupe)

[tmaxxcar]

I am currently making a database to sort through some sales data. On my report, I want it to show the name from a query and the total sum. I can make the report based from one query, but then to add different queries onto the same report I have to use subreport/subform. My issue is that this shows up in a new window on the same page, and I would like it to be all in a simple list. I want to remove the subreport/subform and have a simple text box and total sum for each query that I have. Is there any way that I can create the text box and set it equal to the value from a different query, or do I need to remove all the extra data from the subreport/subform that I do not want? Thanks in advance.

[tmaxxcar]

Nvm, apparently when building an expression in the Access 2013 version, it incorrectly builds the expression. When I have been using the text boxes to build my expression, I get «Expr» Reports![A Report]![A Field]. Instead it should be Reports.[A Report].[A Field]. Now, is there a way for this to be populated even though the [A Report] isn't open?

[pbaldy]

Two thoughts: a union query to join all the query results into one, and using DLookup() to get values from each query.

[tmaxxcar]

Two thoughts: a union query to join all the query results into one, and using DLookup() to get values from each query.

Thanks, ill try both and see if either one of those is what I am looking for.

[pbaldy]

No problem; post back if you get stuck.