One person's "complex" query is another person's "simple" one. Please
explain what you mean by "complex" queries.
A simple definition of a "complex" query to me is one that requires you to
write it in SQL. And yes, it's a lot harder.
--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals" http://www.viescas.com/
(Microsoft Access MVP since 1993)