Welcome to SPN

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

Sign Up Now!

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
    >>
    >>

    >
     

Share This Page