Importing a new query into a report

[Michelle]

I'm sorry if this question has already been asked, but I didn't see it
anywhere.

I have a report that I spent a lot of time designing to make it look exactly
the way I want it to look. So, it'd be a pain to try to format a new report.

Now, I'm wanting to add fields from a new query to it, but when I click on
the "Field List" icon, all I can see is fields from the original query I
used. Is there a way to add another query to the same report?

Thanks,

Michelle

 

[KARL DEWEY]

You can join the second query in the first and then the fields will be
available as they are then a part of it.

 

[vanderghast]

Assuming your report RecordSource is set to the name of a saved query (or to
an SQL statement ), modify the saved query (or the SQL statement) to add the
new fields you want to have.

Sure, if the fields come from ANOTHER query, then I strongly suggest you
made a brand new query from which you will bring all the tables and queries
you need, with the required joins and conditions, and use that brand new
query as record source for your report.


Vanderghast, Access MVP

 

[Michelle]

Thanks, I'll do that.

Michelle

Assuming your report RecordSource is set to the name of a saved query (or to
an SQL statement ), modify the saved query (or the SQL statement) to add the
new fields you want to have.

Sure, if the fields come from ANOTHER query, then I strongly suggest you
made a brand new query from which you will bring all the tables and queries
you need, with the required joins and conditions, and use that brand new
query as record source for your report.


Vanderghast, Access MVP