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!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Problem With Join
I'm querying against 3 tables to get a count by type and year. The problem is that my counts are off as there are values in dbo_t_goal.assignedTo that are not in table ConsolidateGroups.user. I was attempting to do a left join to pick up those values in dbo_t_goal.assignedTo, but I keep...- kshanes
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Missing Operator Error in Update Statement
Good morning, I'm trying to update a column in 1 table based on information in 2 other tables. No matter how I format the SQL I keep getting the error: "Syntax Error (Missing Operator) in Query Expression 'UsersAndGroups.ACL FROM ConsolidateGroups'. The actual statement is below. Any help...- kshanes
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Dynamic Drop Down List
I've always been able to find a resolution to my problems on this site, but for some reason can't seem to find a solution to the following.... In excel, I have a range of cells (i.e. F1 to F26) with various unique entries (i.e. the letters A to Z). I then have cells A1 to A26 reference this...- kshanes
- Thread
- Replies: 2
- Forum: Microsoft: Office
