dont get info i need in query

[Carol R.]

Hi my name is Carol and I'm a novice in access, but my bosses think I know a
lot and I really DONT!! =(

I've been frustated and I'll explain why:
I built a very important DB here in the office that tracks material sold and
purchased.

One of the Table/Query I built is for the purpose of entering adjustments in
price I receive from our customers.

I'm trying to build a query that gathers all the information that HAS NOT
BEEN received. BUT I CAN'T.
The query only shows me the the ones that have been entered already.

Can anyone help me?

Thank you.

=(

 

[rbchildrn]

Hi Carol. I'm in a similar situation, and I've been searching these
groups for a week or two. I think a good first step would be to post
the SQL of the query that won't work so everyone can get an idea of
what you're dealing with. If you aren't familiar with that, you open
the query and switch to SQL View in the View menu, then copy and paste
what you see there to a post. Good luck!

 

[Carol R.]

OK Here's the SQL Querie I'm having trouble with.

SELECT qryPurchaseSort3.ELHTransNo, qryPurchaseSort3.CompanyName,
tblArrivedMaterial.Date, qryPurchaseSort3.PONo, qryPurchaseSort3.ReleaseNo,
qryPurchaseSort3.TimeIn, qryPurchaseSort3.TimeOut,
qryPurchaseSort3.TruckNoName, qryPurchaseSort3.TrailerNumber,
qryPurchaseSort3.Material, qryPurchaseSort3.Material2,
qryPurchaseSort3.Material3, qryPurchaseSort3.BaleCount1 AS
qryPurchaseSort3_BaleCount1, qryPurchaseSort3.BaleCount2 AS
qryPurchaseSort3_BaleCount2, qryPurchaseSort3.BaleCount3 AS
qryPurchaseSort3_BaleCount3, qryPurchaseSort3.WeightNet1,
qryPurchaseSort3.WeightNet2, qryPurchaseSort3.WeightNet3, [ReceivedWeight
Query].ReceivedDate, [ReceivedWeight Query].WeightGross, [ReceivedWeight
Query].WeightTare, [ReceivedWeight Query].[Total Net1], [ReceivedWeight
Query].BaleCount1 AS [ReceivedWeight Query_BaleCount1], [ReceivedWeight
Query].TotalWeight1, [ReceivedWeight Query].BaleCount2 AS [ReceivedWeight
Query_BaleCount2], [ReceivedWeight Query].TotalWeight2, [ReceivedWeight
Query].BaleCount3 AS [ReceivedWeight Query_BaleCount3], [ReceivedWeight
Query].TotalWeight3, [ReceivedWeight Query].AdjustmentReason, [ReceivedWeight
Query].Comments
FROM (qryPurchaseSort3 INNER JOIN [ReceivedWeight Query] ON
qryPurchaseSort3.ELHTransNo = [ReceivedWeight Query].ELHTransNo) INNER JOIN
tblArrivedMaterial ON qryPurchaseSort3.ELHTransNo =
tblArrivedMaterial.ELHTransNo;