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 MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: gregz0012
  • Content: Threads
  • Order by date
  1. gregz0012

    COUNT Complex SELECT

    Hello, I am trying to get the results similar to the below with this... UserID | Exp1 | Exp2 | Exp3 | Exp4 ----------------------------------- 123 | 1 | 9 | 7 | 3 321 | 6 | 2 | 0 | 2 With the following: SELECT (SELECT COUNT(StatusID) FROM Callbacks WHERE StatusID =...
  2. gregz0012

    UPDATE with multiple JOINS

    I have no idea how to do this so maybe some kind sole could help me out. I have been reading documentation and trying to get this to work for hours now :( Here's what I have. UPDATE Users SET Users.FirstName = 'Joe', Users.LastName = 'Bloggs', Users.Manager = Managers.Manager...
  3. gregz0012

    INSERT... SELECT...

    The following Access SQL query returns the following error, and I cannot see why: INSERT INTO Users (Personnel, FirstName, LastName, Manager) SELECT 666, 'joe', 'bloggs', Managers.Manager FROM Managers WHERE Manager.FirstName + ' ' + Manager.LastName = 'James Brown' The query...

Part and Inventory Search

Back
Top