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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Is a sub query the solution?
Sure, goes like... SELECT TOP 10 Avg(items.field1) AS field1, Avg(items.field2) AS field2, items.dags, items.staff_no, staff.staff_name, staff.staff_no FROM staff LEFT OUTER JOIN items on ( staff.staff_no = items.staff_no AND items.dags >=#01.12.2004# AND items.dags <=#01.12.2005# ) GROUP...- bulgroz
- Post #7
- Forum: Microsoft: Access Queries and JET SQL
-
Is a sub query the solution?
Ok, tried that Seems like it’s getting somewhere. now i get the error "The specified field 'staff_no' could refer to more than one table listed in the FROM clause of your SQL statement" (my FROM clause just specifies "FROM staff" like you typed above) I tried removing staff.staff_no from the...- bulgroz
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Is a sub query the solution?
Hi there r937 and thanks for the fast reply. I tried your solution but access just gives me the error "join expression not supported" :(- bulgroz
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Is a sub query the solution?
Hi there what i'm trying to do is something of the sort... SELECT TOP 10 AVG(items.field1) AS field1, AVG(items.field2) AS field2, items.date, items.staff_no, staff.staff_name, staff.staff_no RIGHT JOIN staff ON staff.staff_no = items.staff_no WHERE items.dags >=#01.12.2004# AND items.dags...- bulgroz
- Thread
- Replies: 8
- Forum: Microsoft: Access Queries and JET SQL
