If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Importing a new query into a report
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 |
#2
|
|||
|
|||
Importing a new query into a report
You can join the second query in the first and then the fields will be
available as they are then a part of it. "Michelle" wrote: 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 |
#3
|
|||
|
|||
Importing a new query into a report
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" wrote in message ... 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 |
#4
|
|||
|
|||
Importing a new query into a report
Thanks, I'll do that.
Michelle "vanderghast" wrote: 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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|