Search results

Hi John, Indeed, a very good question. The indexes give a sign of belonging (understand more like a group); say that according to which index they belong, the symbols may have different values. If alpha belongs to T1, alpha has a meaning of 10; if alpha belongs to T4 - it has a value of...

Hi John, Correct, it is a bit complicated and I have been struggling with this data for some time now, therefore I am here. The logic - pls see Table A Inna - Inna has an index of T1 and the symbol is alpha. In table Conversion you see that the combination T1 and alpha - gives you a value of...

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 there, Thanks for reacting; here below the sql: TRANSFORM Sum([tbl AA].[Int FOB]) AS SumOfScore SELECT [tbl AA].P3 FROM [tbl AA] GROUP BY [tbl AA].P3, [tbl AA].[Article #] PIVOT [tbl AA].Rank; The issue us that Int FOB appear in tbl AA in binary format I need everytime to go to that table...

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

Thank you, may I also ask you to help me with the below; I have the: TRANSFORM Sum(YourTableNameHere.Score) AS SumOfScore SELECT YourTableNameHere.Name FROM YourTableNameHere GROUP BY YourTableNameHere.Name PIVOT YourTableNameHere.Rank; and I would like ideally to have: Name Rank 1 Rank 2...

Hi there, Suddenly I got an error msg upon executing this query: Data type mismatch in criteria expression. Do you know how to solve it out? Thank you

Hi Guus, When i attempt to run the second query I get the following msg: Undefined function "Serialize" in expression. Do you know how to fix this? Thx

Hi there, Thanks for the response, however I cannot get the sql right. Here teh dbse - Query - Merging Lines Could you have a look? Thx

hi there, may I ask you to give me a quick example? what would be the sql? Thx

Hi Guus, I am trying to follow yr example, but cannot figure our Query2, here I am sending you the database. Let me know what you think. Greatly appreciated.

thanks guys

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 Sparks, When I follow the above and set rank <5, I get also Rank 0 (besides rank 1,2,3 and 4). For example, for one name I would have Rank 0 instead of Rank 1 - if I manually do the ranking. Do you have any idea on what causes the above? Thank you.

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

Beetle, that mystic neighbour is a damn good one :)...and cheap, indeed that is the idea guys, apologies, but wrote the msg in Word and upon copying and pasting it something must have gone wrong, and yes, I did not check afterwards.

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