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!
-
Excel macro
hi i have excel file with a few 1000 records this is how they look /1/0/105.jpg /7/4/7460.jpg /7/4/7470.jpg /3/2/3240-1.jpg /X/2/X25.jpg /3/2/320.jpg /s/3/s35.jpg /f/i/file_3.jpg /4/1/4150.jpg /1/0/104.jpg now i want to keep only the last part of the record /104.jpg /4150.jpg any help???? or...- mtghr
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
crosstab query
hi i have a table that looks like that SKU parent --- ------ ab1 AA1 ab2 AA1 ab3 AA1 now i want a output that would look like that parent sku1 sku2 sku3 ----- ---- ---- ---- AA1 ab1 ab2 ab3 what i did was i create it a query called qrnkrelated SELECT...- mtghr
- Thread
- Replies: 15
- Forum: Microsoft: Access Queries and JET SQL
-
problem with slef join query please help me
hi this is how my table looks like ITEM UOM PRICE ---- --- ----- ac10 EA 1.99 ac10 BX 6.99 ac10 CS 9.99 now i would like to get a output that would like this ITEM UOM PRICE UOM1 PRICE1 UOM2 PRICE2 ---- --- ----- ----...- mtghr
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
