View is what I needed!

I am able to bypass the Access file (for the visio file to get the data) and it works the same for what I can see. I did have some issues with the SQL statement (it didn't seem to like my IIF statement, so I changed it to a case and it works) for a custom field in the query (was using the "wizard" gui in the SQL Studio at first, then edited the statement in the view).

I guess my next (ambisious) step is to move away from Access altogether and move it to a web app, or tie in to Share Point. They are now telling me that the data needs to be output to Share Point, but I have yet to work with that... don't worry about that for now, as I get rolling, I will post again.

Thanks for the insite!