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 MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Combining Multiple Query Results
thanks sxschech! works like a dream, i was trying to figure out how to nest the SQL statements but couldnt manage it... only one slight change was the deletion of a few unrequired brackets, working code below: SELECT DISTINCT (SELECT Count(ticketsds.id) FROM TicketsDS WHERE...- gazzjones
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Combining Multiple Query Results
Hi, I'm putting together a (hopefully) highly automated database that will allow me to produce clear reports for various areas of responsibility in a new job. I have 3 excel spreadsheets linked directly to access, containing work queue reports. I then run queries that copy new work items into...- gazzjones
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
