Prev: Left Join query not working in Access 2010
Next: cdo or objmessage??
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??