Help with Query please

[roberttkim]

I have an access table that has several company numbers, company account numbers associated with the company numbers, and balances. I am trying to run a query that pulls balances for company 1 and 2 for account numbers 400 and 500. However, when I run the query it brings back other company numbers with balances for the corresponding accounts in addition to what I was trying to get. For example it would bring balances in accounts 400 and 500 for company 1 and 2 which is what i need but it also brings back balances for account 400 and 500 for company 3, 4, 5. Is there a way to set up the criteria to only bring information for the companys that I am looking for?

 

[Kentman]

You need to 'qualify' the query so you would say where company id = 400 OR id = 500 and so on.