-
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.
thanks
-
-
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
-
Forum Rules
|
|