So I have a couple of question when it comes to Queries

Can you somehow combine 2 queries? Let say I have this: 
Please Login or Register  to view this content.
Now the output gives me of other things a number for "type"

I can ALso do this query: 
Please Login or Register  to view this content.
One of the outputs in that table is in row number 14 is the following 2 columns: Column 1 is "Name" and Column 2 is in this case "Bacteria"

So basically its the Name of Item number 2393 is Bacteria

What Id like to do is take that first code I showed you and then look up the ItemType and instead of showing the number it will instead show the items name so if for instance the type was 2393 I would get Bacteria and if it was say 43213 it would output widget or whatever else

lol I think I made that overly complicated so hopefully you can get the idea.... basically just run a query based off the results of another query and merge the results.


And my second question... which I am having major issues finding info on... Can I enter a command in VBA that would refresh a single Query in a workbook?