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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Combining Access Report with Mail Merged Word letters by specific ID's
I have a letter template to which I perform a mail merge to add the inside address. Each letter has a unique ID number associated with each address. The output is sorted by ID. In Access, I create a report that has 2+ pages per ID. Rather than print the letters, then print the reports, and...- Wallo
- Thread
- Replies: 0
- Forum: Microsoft: Access Reports
-
Complex SQL code
Quehey, Your right, it appears to be badly written code because there is no documentation and anytime nesting is done, it causes complications in unravelling. Thanks for your response.- Wallo
- Post #7
- Forum: SAS Institute, Inc. solutions
-
Complex SQL code
Dear Klaz2002: Thanks for your response. In all the SQL books I have referenced, there has been no code written for a 4 way join. I had no idea it could be accomplished. SQL reference books only go as far as one inner select and one outer select without the additional right joins, full...- Wallo
- Post #4
- Forum: SAS Institute, Inc. solutions
-
Complex SQL code
I have inherited SQL code that I know works, but being a novice SQL person, cannot figure out how it is working. I can do the basic create, select, from, where, group by, order by code. The additonal FROMs and SELECTS have me thrown for a loop. Is it poorly written or can someone breakdown the...- Wallo
- Thread
- Replies: 6
- Forum: SAS Institute, Inc. solutions
