Query based on attachment field

[George]

Good Day All,

I would like to know what criteria is used to return records based on a field with data type attachment.

I am using "IsNull" and "IsEmpty" but neither of these work.

[June7]

Bing: query attachment field is empty

This has couple suggestions http://stackoverflow.com/questions/2...-not-in-access

[George]

Hi June7, I do not understand your response. query attachment field in empty.

I am making a query on a table which has an attachment field and some records in the field contains attachments. I want to know how to write the criteria that would return these record containing the attachments.

I tried " not isEmpty" and " Not isNull" with no luck.

Are there other criteria that can be used?

[June7]

I searched web with Bing on those keywords. You could try Google.

Did you review the referenced link?

An attachment field is a multi-value field and therefore must be queried like a multi-value.

This quick test in my db works:

SELECT Umpires.test.FileName, Umpires.UmpID
FROM Umpires
WHERE ((Not (Umpires.test.FileName) Is Null));

[George]

Thanks,

I am unfamiliar with bing. Never used it or knew its purpose.

I did checked the link but it gave the explanation using VBA code. I was looking for a way of simply writing the criteria in the criteria section of the Query window.

I never used or gave thought to a mult-value fields so this will be my first experience. I would try to understand the code you have sent and let you know when I have succeeded.

[June7]

Review this article https://support.office.com/en-US/Art...rs=en-US&ad=US

[George]

Thank,

This would make good reading.

[George]

Thank for your information but for the forum let be say that a quick solution which works is : Is Null

[George]

This is an externally helpful link:

https://support.office.microsoft.com...__toc262850673