Welcome to SPN

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

Sign Up Now!
  1. Guest ji, please consider donating today!
      Become a Supporter    ::   Make a Contribution   
    Monthly Recurring Target: $300 :: Achieved: $95

Querying

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

Tags:
  1. steve s

    steve s
    Expand Collapse
    Guest

    How do i go about seeing if a set of input matches another set on a different
    table.
     
  2. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    "steve s" <steves@discussions.microsoft.com> wrote in message
    news:CB65AF83-2E5C-49DC-B606-89F88AFE7949@microsoft.com...
    > How do i go about seeing if a set of input matches another set on a

    different
    > table.


    Access, being a file server database does everything locally through
    queries, code, forms, and reports. You can write a query, or use code behind
    a form to check and see if the values match. Without being more specific, it
    is difficult to guess what you want to do.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access
     
  3. steve s

    steve s
    Expand Collapse
    Guest

    here is an example

    draw table
    draw date
    ball1
    ball2
    ball3

    etc

    line table
    line date
    number1
    number2
    number3

    etc

    and i want to see if any of the number on line table maches the balls on the
    draw table when the dates are the same.

    "steve s" wrote:

    > How do i go about seeing if a set of input matches another set on a different
    > table.
     
  4. MNewsGroup

    MNewsGroup
    Expand Collapse
    Guest

    nnn
    "Arvin Meyer [MVP]" <a@m.com> wrote in message
    news:u%23pTPxmeGHA.2172@TK2MSFTNGP04.phx.gbl...
    > "steve s" <steves@discussions.microsoft.com> wrote in message
    > news:CB65AF83-2E5C-49DC-B606-89F88AFE7949@microsoft.com...
    >> How do i go about seeing if a set of input matches another set on a

    > different
    >> table.

    >
    > Access, being a file server database does everything locally through
    > queries, code, forms, and reports. You can write a query, or use code
    > behind
    > a form to check and see if the values match. Without being more specific,
    > it
    > is difficult to guess what you want to do.
    > --
    > Arvin Meyer, MCP, MVP
    > Microsoft Access
    > Free Access downloads
    > http://www.datastrat.com
    > http://www.mvps.org/access
    >
    >
     
  5. MNewsGroup

    MNewsGroup
    Expand Collapse
    Guest

    "MNewsGroup" <microsoft.public.access@microsoft.com> wrote in message
    news:2D65EA0B-946F-4638-B67D-5D98513E543A@microsoft.com...
    > nnn
    > "Arvin Meyer [MVP]" <a@m.com> wrote in message
    > news:u%23pTPxmeGHA.2172@TK2MSFTNGP04.phx.gbl...
    >> "steve s" <steves@discussions.microsoft.com> wrote in message
    >> news:CB65AF83-2E5C-49DC-B606-89F88AFE7949@microsoft.com...
    >>> How do i go about seeing if a set of input matches another set on a

    >> different
    >>> table.

    >>
    >> Access, being a file server database does everything locally through
    >> queries, code, forms, and reports. You can write a query, or use code
    >> behind
    >> a form to check and see if the values match. Without being more specific,
    >> it
    >> is difficult to guess what you want to do.
    >> --
    >> Arvin Meyer, MCP, MVP
    >> Microsoft Access
    >> Free Access downloads
    >> http://www.datastrat.com
    >> http://www.mvps.org/access
    >>
    >>

    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page