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

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

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,979
Messages
5,526,026
Members
409,679
Latest member
smars

This Week's Hot Topics

Top