Welcome to SPN

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

Sign Up Now!

Constants in queries

Discussion in 'Information Technology' started by John, Jul 28, 2006.

  1. John

    John
    Expand Collapse
    Guest

    Hi

    I have defined global constants in a module. How can I access these
    constants in a query?

    Thanks

    Regards
     
  2. Loading...

    Similar Threads Forum Date
    Importance of Hukamnama - Some Queries Sikh Sikhi Sikhism Jun 14, 2009
    Queries History of Sikhism Oct 26, 2006

  3. Graham R Seach

    Graham R Seach
    Expand Collapse
    Guest

    John,

    You'll need to create a public function which returns the vallue of the
    constant. Call this function in your query.

    Regards,
    Graham R Seach
    Microsoft Access MVP
    Canberra, Australia
    ---------------------------

    "John" <John@nospam.infovis.co.uk> wrote in message
    news:uUb%23kdudGHA.2416@TK2MSFTNGP03.phx.gbl...
    > Hi
    >
    > I have defined global constants in a module. How can I access these
    > constants in a query?
    >
    > Thanks
    >
    > Regards
    >
    >
     

Share This Page