Search results

Hi Namlim, Thanks for the quick reply. What if we have a duplicate line, say: A15LondonLondon We have duplicated twice on two different lines? Then it will count it twice, right? Thanks.

Hi all, I have the attached data: Basically I would like to populate column three "OUTCOME" according to the following logic: if train A10 has multiple destinations (we see this in the second column) then in outcome I woudl like to have "multiple destinations" if the destination is only one...

Hi there, Thx for yr reply, well for example if I have: Name Value Priority Anna 3 C Anna 9 D Anna 4 E Anna 22 F I would like to get as a final result Anna 3 coz it is a higher priority - C (priorities start from A - to X alphabetically) if I have : Name Value...

Hi all, I have the following table: Name Value Priority Anna 2 A Anna 1 B Anna 3 C Anna 9 D Anna 4 E Anna 22 F Anna 114 G Anna 0 X I am thinking of some formula that would give me the value according to the priority column with the highest priority being A, lowest – x. Logic If I have Anna...

Hi all, I have created that macro in access but seem that cannot get rid of the pop up messages saying: “The existing table will be deleted…” where one needs to answer with yes and no. I see it is a popular topic in the forums, but is it possible to include a query or so, maybe at the...

Hi, I have tried this, but it still deletes the A in front. Are tehre any other fucntions that can give me the last size? many thanks,

Dear all, I have the below query. In a column called Sizes S – I have the below sizes. I would like to take the last one A58, but when I apply the below Right/InStr - I get not only the the comma deleted but also the first capital A. Can anybody help or provide another query that does the...

hi all, I have the following text string: jean.claude.van.dam does anyone know how I can get only the CLAUDE - between the first two dots? Thanks

Hi all, I have the following text string 30.CHARACTER.XXX and I would like to have only the CHARACTER, the text in between dots (.) dows anyone know how I may split it up? Thanks

Hi all, Do you know how to convert dd.mm.yyyy to DD/mm/YYYY (with slashes)? Thanks in advance.

Hi Paul, Do you know by any chance how to convert Binary to Numbers? I have a column with Binary values and would liek to have it in Numbers? thanks

hallo all, I have a column (in a table) populated by binary values and I would like to have this converted to NUMBER. Is that possible by an Update Query? My table is called INDEX; the column is called SIZE Kinldy share with me yr thoughts on this. Thx

Hi Trevor, I am trying to figure out how to get the single value, not everything after the first comma. Thank you

Hi all, I have the following data: Article Sizes Shoes 40,41,42,43 Tshirt s,m,x,xl Jeans 30,32,34 I was wondering is there any query that would easily give me the size between the SECOND and the THIRD comma – for...

Hi all, I have the following issue; I have the below size sequence: 44,46,48,50,52,54,56,58,60,62,66 and I would like to pick up in a query only 44 and 46. For 44 I have CommaPos: InStr([Sizes],",") Num:IIf(InStr([Sizes],",")=0 Or...

Hi John, Here maybe a better example of what we are trying to achieve with my classmates: We have that shoe shop: Article - Size - Price - Index ABC - 50,52 - $20 - T1 ABC - 60,62 - $50 - T1 123 - 66,68 - $110 - T4 123 - 70,72 - $80 - T4 Conversion Table Index - SINGLE Size - Value...

Hi VBAInet, Correct, however I have way too many entries and I cannot figure out how to normalize my data; thats why I am kinda thinking of a way around. If you think of anythin, pls let me know. Thx

Hi John, I am trying to implement your solution, however my data consists of over 36000 names (different names) and the symbols per name could be up to 20. Therefore although your solutions seems to work, it works only with a limited number of entries or am I missing something? I originally...

Thank you, John! Thx indeed, I was stuck on it for quite some time!

Hi all, I have the following table: Table A Person - Symbol Inna - beta, theta, delta Anna - beta, theta Maria - beta, theta, delta, gamma, theta2 Does anyone know how I can get the entries from the Symbol line in separate columns? Thanks.