QUERY FIELD SUM
in [Queries]
|
From: gambler on 4 May 2010 20:01 Thanks for responding. "KARL DEWEY" wrote: > 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
From: gambler on 4 May 2010 20:27 I did some research on google and i understand you equation. My problem now is i will have maybe 30 IIf statements to add up. Since they will be going from left to right across my sheet, how would i add them . I can write one statement like you did above. I would really be long. How do you suggest i do it,and i will do some more reading. Im going from left to right because im doing horse racing and im look at each horse in the race seperetyl. Sure appreciate any help Thanks Karl 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: PieterLinden via AccessMonster.com on 4 May 2010 20:36 gambler wrote: >I did some research on google and i understand you equation. My problem now >is i will have maybe 30 IIf statements to add up. Since they will be going >from left to right across my sheet, how would i add them . I can write one >statement like you did above. I would really be long. How do you suggest i do >it,and i will do some more reading. >Im going from left to right because im doing horse racing and im look at >each horse in the race seperetyl. >Sure appreciate any help >Thanks Karl >ed Usually that's a sign that you need to normalize. Generally, tables should be tall and slim, not short and fat. Short and fat is almost always an indication of design problems. Then you can use totals queries. Much easier and faster. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201005/1
From: gambler on 4 May 2010 21:31 "PieterLinden via AccessMonster.com" wrote: > gambler wrote: > >I did some research on google and i understand you equation. My problem now > >is i will have maybe 30 IIf statements to add up. Since they will be going > >from left to right across my sheet, how would i add them . I can write one > >statement like you did above. I would really be long. How do you suggest i do > >it,and i will do some more reading. > >Im going from left to right because im doing horse racing and im look at > >each horse in the race seperetyl. > >Sure appreciate any help > >Thanks Karl > >ed > > Usually that's a sign that you need to normalize. Generally, tables should > be tall and slim, not short and fat. Short and fat is almost always an > indication of design problems. Then you can use totals queries. Much easier > and faster. > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201005/1 > > . >
From: gambler on 4 May 2010 21:32 Ill have to read some more. Thanks ed "PieterLinden via AccessMonster.com" wrote: > gambler wrote: > >I did some research on google and i understand you equation. My problem now > >is i will have maybe 30 IIf statements to add up. Since they will be going > >from left to right across my sheet, how would i add them . I can write one > >statement like you did above. I would really be long. How do you suggest i do > >it,and i will do some more reading. > >Im going from left to right because im doing horse racing and im look at > >each horse in the race seperetyl. > >Sure appreciate any help > >Thanks Karl > >ed > > Usually that's a sign that you need to normalize. Generally, tables should > be tall and slim, not short and fat. Short and fat is almost always an > indication of design problems. Then you can use totals queries. Much easier > and faster. > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201005/1 > > . >
First
|
Prev
|
Next
|
Last
Pages: 1 2 3 4 Prev: Left Join query not working in Access 2010 Next: cdo or objmessage?? |