The best way I've seen to do this is to use a passthrough query with the sql code and bring it into an Access report. You may have to do some minor tweaking but I've done it with a few reports.
I know I can do it from Access, but I want to actually run the SQL report.
Can a hypertext field allow that?
I don't need the report IN access, I just want to run it.