Joining tables. Need Help

I have 2 tables in an Access database and am trying to join them.
I am writing an employee time clock program that pulls the employee Id from one table (Associate) , but need to write the time in(out) to the other table(Time). I am using the statement

SQLQuery = "SELECT * FROM Associate INNER JOIN Time ON Time.EmpId=Associate.EmpId"

My error reads syntax in From clause.

The Assoicate table opens up fine in the form load, but the Time table does not.

Please help
[505 byte] By [lavon] at [2007-11-18 8:09:04]
# 1 Re: Joining tables. Need Help
Well, I guess Time is one of the reserved words.. So..

SQLQuery = "SELECT * FROM Associate INNER JOIN [Time] ON [Time].EmpId=Associate.EmpId"

:)
Thread1 at 2007-11-9 23:46:47 >