Results 1 to 3 of 3

Thread: help with MS access query

  1. #1
    Join Date
    Jan 2008

    Question help with MS access query

    I need help to create a query from a table.
    statement s/b

    select from table, where id# has several account#
    or where acct# has several invoice#. let say I have 100 account# and therefore cannot use like"".
    what will be my best chance.

  2. #2
    Join Date
    Sep 2002
    What's table schema?

  3. #3
    Join Date
    Nov 2006
    Do you mean that the ID could have any of several account numbers? If so, you can use the design grid and put each account number on a separate line. Access treats that as an "OR" statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts