Forum

creating a query fr...
 
Notifications
Clear all

creating a query from another query

4 Posts
2 Users
0 Reactions
120 Views
(@paxsft)
Posts: 14
Eminent Member
Topic starter
 

I created a New Query from database and loaded it with a connection only. Can I create another query from the query that you just created?

I tried creating a blank query then entering =Excel.CurrentWorkbook() in the formula bar but it does not show the connection only query that i created earlier.

 

Thanks

 
Posted : 13/01/2017 2:25 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Bill,

Yes, you can reference another query in a query. See session 4.19 for instructions on how to do this.

Kind regards,

Mynda

 
Posted : 13/01/2017 11:42 pm
(@paxsft)
Posts: 14
Eminent Member
Topic starter
 

Thank you, I must have slept thru that tutorial .... 

 
Posted : 14/01/2017 12:16 pm
(@mynda)
Posts: 4761
Member Admin
 

🙂 I'll have to make them more exciting then!

 
Posted : 16/01/2017 6:58 pm
Share: