Hi - I can get this to work in SQL Server - but when also trying to make
the application compatible with MS Access I get an error:

Select tblfaqnetgroups.group_name from tblfaqnetroles
Inner Join tblfaqnetgroups ON tblfaqnetroles.group_id =
tblfaqnetgroups.group_id
Inner Join tblaccess ON tblfaqnetroles.user_id = tblaccess.user_id
AND tblaccess.user_id = 1

The error in Access is:

Syntax error (missing operator) in query expression
'tblfaqnetroles.group_id = tblfaqnetgroups.group_id
Inner Join tblaccess ON tblfaqnetroles.user_id = tblaccess.user_id'

Any help would be much appreciated,

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!