I've tried many ways to get a simple Select-with-Join statement to
work without success. I've stripped this down to barely nothing and
it still doesn't work If I can't get this simple statement to work,
how will I ever add the necessary "where" clause with parameters and
the "Order By" clause???

Here's the simple statement:

sqlquery = "select endate, endiv, endept, enaccount, wonumber,
woaccount from (entries join wotrans) on (entries .enaccount =
wotrans.woaccount) "

That's all on one line. The error is "Syntax error in JOIN
operation."

You can do a select, join, where and order by statement in VBA Excel
2003 against an Access Database, can't you?

Hexman