Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Even Numbers

Discussion in 'Information Technology' started by msmuzila@gmail.com, Jul 28, 2006.

Tags:
  1. msmuzila@gmail.com

    msmuzila@gmail.com
    Expand Collapse
    Guest

    I have a query that uses a table with the numbers 1 through 30

    I want to filter the query to:

    If forms!frmParts!Row_Parts = 1 And forms!frmParts!Parts_Per_X_Length
    = 1
    show all numbers
    Else
    filter to show only the even numbers


    Thanks
     
  2. Loading...


  3. fredg

    fredg
    Expand Collapse
    Guest

    On 26 Jun 2006 08:55:51 -0700, msmuzila@gmail.com wrote:

    > I have a query that uses a table with the numbers 1 through 30
    >
    > I want to filter the query to:
    >
    > If forms!frmParts!Row_Parts = 1 And forms!frmParts!Parts_Per_X_Length
    > = 1
    > show all numbers
    > Else
    > filter to show only the even numbers
    >
    > Thanks


    You can use the MOD operator to determine if a number is odd or even:

    If [FieldName] Mod 2 = 0 then
    'It's Even
    Else
    ' It's Odd
    End If
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  4. Al Camp

    Al Camp
    Expand Collapse
    Guest

    Use the Mod function.
    You don't seem to indicate what field or value you're referring to as
    > filter to show only the even numbers


    If [SomeNumber]Mod 2 = 0 Then

    Only Even [SomeNumbers] will = 0

    --
    hth
    Al Camp
    Candia Computer Consulting - Candia NH
    http://home.comcast.net/~cccsolutions

    <msmuzila@gmail.com> wrote in message
    news:1151337351.265210.212000@c74g2000cwc.googlegroups.com...
    >I have a query that uses a table with the numbers 1 through 30
    >
    > I want to filter the query to:
    >
    > If forms!frmParts!Row_Parts = 1 And forms!frmParts!Parts_Per_X_Length
    > = 1
    > show all numbers
    > Else
    > filter to show only the even numbers
    >
    >
    > Thanks
    >
     
  5. msmuzila@gmail.com

    msmuzila@gmail.com
    Expand Collapse
    Guest

    I want to filter the only field in the query: the Amount field
     

Share This Page