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. OP
    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
    >
    >
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page