Assigning work to team 1 and team 2
in [Forms]
|
From: BruceM via AccessMonster.com on 26 May 2010 13:31 This expression will return true for odd numbers, and false for even: [RepNum] Mod 2 = 1 I don't begin to understand what you are trying to do, but if your request is simply for a way to identify odd and even integers, this should do it. VBA Help has more information about the Mod operator, but essentially it is the remainder when the first number ([RepNum] is divided by the second number (2). bob wrote: >Jeff > >What I am trying to do is lookup the data in table tblTeamCounter field >RepNum from form IncidentData if this is an even number then >Field Team1 on the IncidentDate form has a true value if its an odd number >then Field Team2 has a true value. The rest I can sort out, it is how to >code the lookup the value in the table and how it knows if it is odd or even >I am stuck with. > >Hope this helps explains what I am trying to do. > >Thanks, > >Bob > >> Bob >> >[quoted text clipped - 35 lines] >>> >>> Bob -- Message posted via http://www.accessmonster.com
From: bob on 27 May 2010 07:17
Bruce That was all I needed, I how have it working. Thanks, Bob "BruceM via AccessMonster.com" <u54429(a)uwe> wrote in message news:a89738dda08b0(a)uwe... > This expression will return true for odd numbers, and false for even: > [RepNum] Mod 2 = 1 > > I don't begin to understand what you are trying to do, but if your request > is > simply for a way to identify odd and even integers, this should do it. > VBA > Help has more information about the Mod operator, but essentially it is > the > remainder when the first number ([RepNum] is divided by the second number > (2). > > > bob wrote: >>Jeff >> >>What I am trying to do is lookup the data in table tblTeamCounter field >>RepNum from form IncidentData if this is an even number then >>Field Team1 on the IncidentDate form has a true value if its an odd number >>then Field Team2 has a true value. The rest I can sort out, it is how to >>code the lookup the value in the table and how it knows if it is odd or >>even >>I am stuck with. >> >>Hope this helps explains what I am trying to do. >> >>Thanks, >> >>Bob >> >>> Bob >>> >>[quoted text clipped - 35 lines] >>>> >>>> Bob > > -- > Message posted via http://www.accessmonster.com > |