Help with Query please

roberttkim

Board Regular
Joined
Mar 5, 2009
Messages
96
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?
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Kentman

Active Member
Joined
Apr 26, 2010
Messages
257
You need to 'qualify' the query so you would say where company id = 400 OR id = 500 and so on.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,730
Messages
5,524,493
Members
409,584
Latest member
RedHelp

This Week's Hot Topics

Top