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!
-
Block Query
Hi there! I have a query which left joins a table and five other queries. I have to write a similar query for 19 other tables. Is there any way I can write the five queries directly as subqueries so i don't have to make 6x19= 114 query files. If not, would it be possible to reuse...- ERTW
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
-
Help!!
Thanks Rick, Pretty neat idea. However, I only need combinations of a lecture section ( eg 101 ) and a lab section ( L1x), which means just 101-L1A and 101-L1B, and not L1A-L1B. Also there are instances where there are 2 lecture sections (101 and 102) but I want only one to show up in each...- ERTW
- Post #3
- Forum: Microsoft: Access Other topics
-
Help!!
Hi there, I've just started using Access and databases in general. I have a list of course timetables that need to be grouped. course section day time `````` ``````` ``` ```` xxxx123 101 xxxx123 L1A xxxx123 L1B Is it possible to write a query that returns...- ERTW
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
