First, I tried searching multiple times for a similar post, but I can't get the search to return any hits for "SQL", and I don't know why. I can see SQL in the first page, but my searches returned literally no results. I don't know what I did wrong, but I did TRY to search. My Google searches also just fill me full of results about how various other SQL databases can handle way more than Access or how to type SQL into Access; neither of which answer the question I'm trying to ask.
I'm relatively new to Access and I don't understand when or why you would want to write SQL directly instead of using the built in Query interface that does the SQL for you. Is it like how with Excel you can do a lot more with VBA than you can with formulas and "base" excel, or is it just that Access lets you see the SQL code, but there's really no benefit to typing the SQL code directly?
Thanks for your time!
-Opie
Bookmarks