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!
-
Conditional join? - only part of the field matches...
I am using Access to organize data from various spreadsheets and generate some information. I'm running into issues with a multi-table query where some of the data in one table is entered as 123456-7890 and in another it is 123456. Those same columns also have data that matches exactly, i.e...- BC98121
- Thread
- Replies: 6
- Forum: Microsoft: Access Queries and JET SQL
-
Use "Text to Columns" in code?
Hello. I have been tasked with cleaning up an old spreadsheet with over 14,000 rows of data. Essentially the spreadsheet was designed to track when something was done, and the initials of the person who performed the action. When the spreadsheet was first used both the initials and the date...- BC98121
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
