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!
Recent content by evetselas
-
Psedu foreach
Thanks. I've done it as a report for the moment. I've not used subdatasheets, I'll look at that. Good help, thanks to all.- evetselas
- Post #7
- Forum: Microsoft: Access Queries and JET SQL
-
Psedu foreach
Thanks. I haven't got any SQL statement that can do this. What I'm trying to get is a list like Assem1 widget1 widget2 widget3 Assem2 widget4 widget5 or similar but and Access SQL query I can think of outputs Assem1 widget1 Assem1 widget2 Assem1 widget3...- evetselas
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Psedu foreach
I have a table which, simplified, consists of assembly,part Each assembly has many parts. I want to run an SQL which only outputs the first example of each assembly followed by the parts in that assembly. I know I can easily do this in a macro using a foreach loop but I am trying to make this...- evetselas
- Thread
- Replies: 6
- Forum: Microsoft: Access Queries and JET SQL
