Syntax wise this looks perfect but not sure what stops access executing it...

select *
from timesheet t
        inner join teammaster tm on t.teamid = tm.teamid
        inner join worktype w on t.wtid = w.wtid
where t.tsid = 56403

it says "Syntax error missing operator..bla bla"

Rupen Anjaria.:)
------------------
We CAN'T avoid problems, but can solve it.

Shouldn't that be:

select tablename.fieldname, tablename.fieldname, etc (not * when more than one table)
from timesheet t, teammaster As tm, worktype As w
        inner join teammaster tm on t.teamid = tm.teamid
        inner join worktype w on t.wtid = w.wtid
where t.tsid = 56403

Did that help? I would do this in the designer, and then copy the SQL from SQL View.


mmcdonal

forget "AS" between timesheet and t it should be
select *
from timesheet AS t

Rupen Anjaria.:)
------------------
We CAN'T avoid problems, but can solve it.