So I ahve a very large and complex database in Access and I need to create a
series of Automatically updating Graphs to monitors processes. I have my
queries created in Access and want to create the graphs on excel so I can put
multiple graphs on a single page. The query has results when ran in Access
but when I create the data connection in Excel it comes across empty. This is
the SQL to the query

SELECT Max(dbo_SSO_001.FILENAME) AS MaxRunID
FROM dbo_SSO_001
WHERE (((dbo_SSO_001.PROCESS) Is Not Null))
HAVING (((Max(dbo_SSO_001.FILENAME)) Like "*SA01*"));

Some basic trouble shooting has shown me that if I remove the "HAVING"
clause it will work fine but every time I put it back in the results come
back with nothing? Is this a known issue or am I missing some fundemental?