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 2010 Next: cdo or objmessage?? 