From: gambler on 4 May 2010 16:04 In have the following in my first field. K:IIF([PL4HX4.RK]=1,"2",IIF([PL4HX4.RK]=2,"1","")) I have the following in my second field. H:IIF([PL4HX4.RH]=1,"2",IIF([PL4HX4.RH]=2,"1","")) What would i write in my third field to get the sum of K + H ? Thanks ed From: ghetto_banjo on 4 May 2010 16:27 should be as easy as: L: [K] + [H] However, you see that you are returning "1" which is a string, as opposed 1 the number. You might want to change the values to 2, 1, and 0 depending on what you are trying to accomplish. From: KARL DEWEY on 4 May 2010 16:43 >> What would i write in my third field to get the sum of K + H ? Z: IIF([PL4HX4.RK]=1, 2, IIF([PL4HX4.RK]=2, 1, 0)) + IIF([PL4HX4.RH]=1, 2, IIF([PL4HX4.RH]=2, 1, 0)) Using the quotes around the digits to show for condition results would give you this -- 21 or 11 or 12 or 22 instead of 3 or 2 or 3 or 4. If you use the quotes it is text output so that when you use the plus sign with text it concatenates the information rather than summing. -- Build a little, test a little. "gambler" wrote: > In have the following in my first field. > K:IIF([PL4HX4.RK]=1,"2",IIF([PL4HX4.RK]=2,"1","")) > I have the following in my second field. > H:IIF([PL4HX4.RH]=1,"2",IIF([PL4HX4.RH]=2,"1","")) > What would i write in my third field to get the sum of K + H ? > Thanks > ed From: gambler on 4 May 2010 19:16 KARL Do you give any help over the phone? If so what do you charge? Thanks ed "KARL DEWEY" wrote: > >> What would i write in my third field to get the sum of K + H ? > Z: IIF([PL4HX4.RK]=1, 2, IIF([PL4HX4.RK]=2, 1, 0)) + IIF([PL4HX4.RH]=1, > 2, IIF([PL4HX4.RH]=2, 1, 0)) > > Using the quotes around the digits to show for condition results would give > you this -- 21 or 11 or 12 or 22 instead of 3 or 2 or 3 or 4. > > If you use the quotes it is text output so that when you use the plus sign > with text it concatenates the information rather than summing. > > -- > Build a little, test a little. > > > "gambler" wrote: > > > In have the following in my first field. > > K:IIF([PL4HX4.RK]=1,"2",IIF([PL4HX4.RK]=2,"1","")) > > I have the following in my second field. > > H:IIF([PL4HX4.RH]=1,"2",IIF([PL4HX4.RH]=2,"1","")) > > What would i write in my third field to get the sum of K + H ? > > Thanks > > ed From: KARL DEWEY on 4 May 2010 19:28 No phone, no web sites, no viewing your web site. If the Access problem seems interesting I respond. -- Build a little, test a little. "gambler" wrote: > KARL > Do you give any help over the phone? If so what do you charge? > Thanks > ed > > "KARL DEWEY" wrote: > > > >> What would i write in my third field to get the sum of K + H ? > > Z: IIF([PL4HX4.RK]=1, 2, IIF([PL4HX4.RK]=2, 1, 0)) + IIF([PL4HX4.RH]=1, > > 2, IIF([PL4HX4.RH]=2, 1, 0)) > > > > Using the quotes around the digits to show for condition results would give > > you this -- 21 or 11 or 12 or 22 instead of 3 or 2 or 3 or 4. > > > > If you use the quotes it is text output so that when you use the plus sign > > with text it concatenates the information rather than summing. > > > > -- > > Build a little, test a little. > > > > > > "gambler" wrote: > > > > > In have the following in my first field. > > > K:IIF([PL4HX4.RK]=1,"2",IIF([PL4HX4.RK]=2,"1","")) > > > I have the following in my second field. > > > H:IIF([PL4HX4.RH]=1,"2",IIF([PL4HX4.RH]=2,"1","")) > > > What would i write in my third field to get the sum of K + H ? > > > Thanks > > > ed  |  Next  |  Last Pages: 1 2 3 4 Prev: Left Join query not working in Access 2010Next: cdo or objmessage??