I have built a database in access and made a query witch works in access.
This query is suppose to get get all [ID] fiels in a table wich have the date 'Dags' and then get all the [name] fields in another table that have the same ID as those chosen earlier. This is suppose to be the source for a data object.

the code I wrote was this:
Data7.RecordSource = "SELECT [Stundartafla Starfsfóls].Kennitala, '"
"' Staff.NAFN FROM [Stundartafla Starfsfóls] '"
"' INNER JOIN Staff ON '"
"' [Stundartafla Starfsfóls].Kennitala = Staff.KT '"
"' WHERE ((([Stundartafla Starfsfóls].Maetir_dags)= '"
"' Dags ))"

and I get the errormessage: Syntax error (missing operataor) in query expression 'staff.NAFN'"