Hello Nicholas Cavaliere,
I see that you are new to the community forums here at Tableau. Welcome to the community. There are a few different posts in the forums that touch on this topic. Did you search the forums and review this post? - Why does tableau not display all the queries i have in my access database when i connect to the database in tableau
Here are a few other posts that may also be helpful: https://community.tableau.com/search.jspa?q=access+query
If these do not address or answer the ongoing issue, please share what was tried and we can dig in more to see what's up.
Thanks for the quick reply. I've read that thread before and I don't believe any of the situations mentioned apply. It mentions that the Access query uses a parameter or a query references a field name that doesn't exist. I don't believe any of these apply. The queries are referencing data from a make table query that is run prior to me connecting to the data in tableau. The secondary queries then query the results from the previous queries. The queries are not cross-tab or union queries.
Some additional information that may be helpful:
The make table query, 'qry_remedy tickets' pulls in data from a data source I am connected to in access and populates the created table.
After running that query I run 'qry_Calls Taken' and 'qry_Total Tickets' to extract the total calls and total tickets by person.
The final step is to run the 'qry_Tickets to Calls' where I do a calculation from the data in the previous two queries.