Using MS Access to pull invoices

[cfcanter]

Here is my query:

SELECT POP_RecptHistoryHeader.ReceiptType, POP_RecptHistoryHeader.ReceiptDate, POM_RecptHistoryLine.ItemNumber, POM_RecptHistoryLine.Description, POM_RecptHistoryLine.UnitOfMeasure, POM_RecptHistoryLine.ReceiptQty, POM_RecptHistoryLine.ReceiptAmount, POM_RecptHistoryLine.UnitCost
FROM POP_RecptHistoryHeader INNER JOIN POM_RecptHistoryLine ON POP_RecptHistoryHeader.ReceiptNumber = POM_RecptHistoryLine.ReceiptNumber
WHERE (((POP_RecptHistoryHeader.ReceiptType) Like "I") AND ((POP_RecptHistoryHeader.ReceiptDate)>#1/1/2005#));


I am trying to pull every invoice since 1/1/05. I cannot use standard reports b/c of the way things were done by operations is so FUBAR that I need to access the data via a report writer and modify to fit my needs.

the query hands up. I tried running it on Sunday and leaving but no data was ever returned. But the data is there when I look at the tables manually. Any suggestions as to how to fix my data.

Craig Canter
Controller
Elgin IL

 

[BigLouie]

The best way to do this is to write a separate query for each table then write a make table query using all the queries on MAS putting in the parameters in the make table query, NOT in the queries on MAS. Should run fine that way. Do it all the time.

 

[cfcanter]

Breaking down the query into separate tables worked great! Thank you!

One further question - where do I find invoiced quantity? I have invoiced amount but not the qty.

Craig Canter
Controller
Elgin IL