Filter query that only item of inventory with the attachment will show

[hfsitumo2001]

Hello, how can I filter my query to show only the one has attachment. What should we say in the expression. I have default attachment is "nopicture.png", the picture of paper clip. Now I want to say not equal to file name "nopicture.png". Thank you

 

[Isaac]

In the case of this query, my table name was 20210112, so ignore that.

Note I just dragged down Attachments and put Is Null. It works accurately for me with a table whose column type is Attachment. in my case it was a sharepoint link, hopefully will work same for you in access table back end.

 

[hfsitumo2001]

Thank you Isaac but mine is the one that I want with the attachment so, Is not null

 

[Isaac]

Oh, sorry - right, that should work, does it?

 

[hfsitumo2001]

Oh, sorry - right, that should work, does it?

Thank you Isaac, yes it works for me. now the thing that is not yet done, my question on how to include the supplier in my inventory report

 

[Isaac]

More information, please.

 

[hfsitumo2001]

Oh, sorry - right, that should work, does it?

Hi Isaac, can we add the picture in the report?, in form yes I can make but I do not know for the report

 

[Isaac]

please post a new question on this

 

[hfsitumo2001]

More information, please.

Thank you Isaac. This is my last problem now: for my Inventory report I need to include supplier, and the date, but I want to chose the line ( see the report) with the latest date (the most recent date). This is the query and the result. My question how can we make the result to only one line per item with the most recent date. So who ever the suppier with the recent order date, that the one to be included. Thank you for your help.

SELECT Inventory.ItemCode, Inventory.Description, Inventory.IUnitPrice, Inventory.QtyPerCase, Inventory.UOM, Sum(Inventory.Inv_Qty) AS StockInHand, [StockInHand]*[IUnitPrice] AS InventoryValue, PurchaseDetails.ItemCode, PurchaseOrder.OrderDate, Suppliers.Supplier
FROM Suppliers INNER JOIN (PurchaseOrder INNER JOIN (Inventory INNER JOIN PurchaseDetails ON Inventory.ItemCode = PurchaseDetails.ItemCode) ON PurchaseOrder.ID = PurchaseDetails.PODetailsID) ON Suppliers.SupplierID = PurchaseOrder.SupplierID
GROUP BY Inventory.ItemCode, Inventory.Description, Inventory.IUnitPrice, Inventory.QtyPerCase, Inventory.UOM, PurchaseDetails.ItemCode, PurchaseOrder.OrderDate, Suppliers.Supplier
HAVING (((Sum(Inventory.Inv_Qty))>0));