Template Query Question

[steve21nj]

Good morning,

I have a question about an Issues template database provided. I’m not sure why I haven’t been able to grasp the idea, but there is a query labeled “Issues Chart Source,” that is referencing two queries and a table.
The two queries are “Contacts_OpenedBy” and “Contacts_AssignedTo” that do not exist in the All Access Objects navigation panel.

My question is, how were the queries created and how is it able to reference them if they are not there?

I’d like to recreate those queries to have a better understanding, but I’m having trouble understanding what they originally did. Or am I just being stupid today.

 

[David R]

Did you make this database? Is it possible they're just hidden?

http://office.microsoft.com/en-us/a...sing-the-navigation-pane-HA001213879.aspx#BM9

 

[steve21nj]

The database is from the Microsoft main site here: http://office.microsoft.com/en-us/templates/results.aspx?qu=issues&ex=2&av=all#ai:TC001225348||

I tried your solution before, the appropriate boxes were checked.

Any other suggestions?

 

[CJ_London]

The queries have been aliased - if you look at the sql

SELECT Contacts_AssignedTo.[Contact Name] AS [Assigned To Name], Contacts_OpenedBy.[Contact Name] AS [Opened By Name], Issues.*
FROM [[COLOR=red]Contacts Extended] AS Contacts_OpenedBy[/COLOR] RIGHT JOIN [COLOR=red]([Contacts Extended] AS Contacts_AssignedTo[/COLOR] RIGHT JOIN Issues ON Contacts_AssignedTo.ID = Issues.[Assigned To]) ON Contacts_OpenedBy.ID = Issues.[Opened By]
WHERE (((Issues.Status)<>"Closed"));