Search results

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

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.

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

Hi all, I have the following two tables (you may also refer to attachment) Table A Person Index Symbol Inna - T1 - alpha Inna - T4 - beta, theta, delta Maria - T1 - delta, theta Maria - T4 - alpha, gamma And Table Conversion Symbol Index Combination Symbol value Alpha - alphaT1 - 10 Beta -...

Hallo, I need to make the following query: I have two tables: one consists of articles with NO prices, the other one consists of the same articles but with two different prices – ie two lines with two different prices. I am wondering how I may populate the first table with the higher of the two...

Hi all, I have the following table: Price Valid from Valid to $2 01 Jan 12 31 Mar 12 $10 01 Apr 12 30 Jun 12 $11 01 May 12 31 July 12 $20 01 Jul 12 31 Dec 12 TODAY is June 22n2, 2012 – what query should...

Hi all, I get the below error msg: Data type mismatch in criteria expression when running a macro in Access; the only way to solve it is to go to the source table, change one field from BINARY to TEXT which solves the issue, however I would like to avoid doing this interim step manually...

Hallo all, I have the following table: Name Score 1 Score 2 Anna (blank) 10 Anna 8 (blank) Inna 7 8 Ivan 9 2 For Annam, I have the score in two lines and blank fields, how may I get the above in one line, thus for Anna Name Score 1 Score 2 Anna 8 10 Thanks in advance

Hi all, I have a table consisting of one column "Names" where I have the names of the participants in a competition; however amoung these names I also have entries like P1, P2, etc which stands for a participant whose name is not known, therefore a generic name was assigned - P1 -stands for...

hi all, I have the below iif: iif([table1]![ldp]="1", "Yes", iif([table1]![ldp]="0", "No")) however I would like to include another condition: iif([table1]![ldp]=" ", "Yes") ie if the ldp is BLANK, give me again YES Does anybody know how to combine the above three conditions in one...

Hi all, I am trying to figure out a query that puts multiple entries in one line in order, pls see below: Column A Column A 4, 2, 1, 3 1,2,3,4 A, C, B, D A,B,C,D I have a table with column A, and it is important that before I start manipulating the data that it is in order. Does any of you...

Hi all, I am trying to figure out a transpose query in access; I have the below table: Name Score Rank Inna 4 1 Anna 5 2 George 2 1 And I would like to have something like the following; I have only two Ranks: Rank 1 and Rank 2 – these I would like to be my...