Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ric2020

  1. ric2020

    inner join in access problem

    Superb, All works great. A Million Thanks, Rick
  2. ric2020

    inner join in access problem

    Still get 'Syntax error in FROM clause' I'm using access 2002 on XP, if that helps?
  3. ric2020

    inner join in access problem

    Ive tried SELECT A.Users AS Creator, B.Users AS Closer, ToDo.* FROM Todo (INNER JOIN Users A ON ToDo.Createdby=A.UserID) INNER JOIN Users B ON ToDo.Closedby=B.UserID; My two tables are as follows:- Users UserID as Autonumber Name as text Todo Createdby = userID , as number Closedby = userID...
  4. ric2020

    inner join in access problem

    Thanks for the quick replay. I need the result to simply print a report of all todos with the userid's replaced with username. I have tried the suggestion from PHV, but unfortunately i get, 'syntax error in from clause'. i have tried various brackets, but no success.
  5. ric2020

    inner join in access problem

    Hi, I am trying to join two tables to produce a report. A Todo table has two fileds that reference the user table. I can successfully join on one field. SELECT Users.User, ToDo.* FROM todo INNER JOIN Users ON (Users.UserID = ToDo.Closedby) But trying to join on both fields i have problems. I...
See more

Part and Inventory Search

Back
Top