Recent content by dastr

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