Search results for query: *

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...

i wiill try to run a select query against this query SELECT Related.SKU, Related.Parent, Count(Related_1.SKU) AS RankFROM Related INNER JOIN Related AS Related_1 ON Related.Parent = Related_1.ParentWHERE (((Related_1.SKU)<=[Related].[SKU]))GROUP BY Related.SKU, Related.Parent; and will add...

the above code will not work since i need to exlcude SKU001 from the new table that i am trying to create so i am looking into unpivot all but sku001

i am trying to figure out now how to unpivot a table my pivot table has 63 fields SKU001 sku002 sku003 ...... SKU063 in order to unpivot them will i need to type all the fields names ir is there a easier way to do that

thank you vey much i got the handle on pivot and it really help me a lot

i fixed the issuue there ware some dublicatesd SKU i ran query to delte all the dublicates

how can i send you my data??? my email address moshe.rosenberg @ gmail.com email me where i can send you the data file?

still something wrong in some rows sku001 in empty and sku004 has valueshuoldt it allways start on 001???

still something wrong in some rows sku001 in empty and sku004 has value shuoldt it allways start on 001???

now the output is ok my issues is that the fields look like that SKU1 SKU10 SKU102 SKU11 SKU12 i wan to add a sort by that will give me SKU1 SKU2 SKU3 etc can you give me the syntax for that

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...

tanks a million i was i n a rush and didnt focus what i am doing now its great!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ok i just treid to run the first query and ms access doesnt like this part Count(tblPrice_1.ITEM) AS PriceNumFROM tblPrice gives me error on tblPrice the Select satement includes a reserved word or an argument name that is misspelleed or missing or the punctuantion is incorrect

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 ---- --- ----- ----...