return blanks in query result ...

[Guest]

In the source table for the query below, Ccy is a numeric field and there are
a number of blank fields. I want the query to return only records where Ccy
is empty(I have tried "Isempty" "IsNull" "IsMissing" and the the result is
always the same, no records. Ther query I have tried is

SELECT inclgs2.Ccount, inclgs2.Ccy, inclgs2.cLcy, inclgs2.cDate,
inclgs2.cTxn, inclgs2.cRef
FROM inclgs2
WHERE (((inclgs2.Ccy)=IsMissing([Ccy])));

Any suggestions

 

[Guest]

Try

SELECT inclgs2.Ccount, inclgs2.Ccy, inclgs2.cLcy, inclgs2.cDate,
inclgs2.cTxn, inclgs2.cRef
FROM inclgs2
WHERE inclgs2.Ccy Is Null

Or, if the Ccy field type is string it can be empty
SELECT inclgs2.Ccount, inclgs2.Ccy, inclgs2.cLcy, inclgs2.cDate,
inclgs2.cTxn, inclgs2.cRef
FROM inclgs2
WHERE Trim(inclgs2.Ccy) = "" Or inclgs2.Ccy Is Null

 

[Guest]

Thank you Ofer
--
thanks as always for the help

Try

SELECT inclgs2.Ccount, inclgs2.Ccy, inclgs2.cLcy, inclgs2.cDate,
inclgs2.cTxn, inclgs2.cRef
FROM inclgs2
WHERE inclgs2.Ccy Is Null

Or, if the Ccy field type is string it can be empty
SELECT inclgs2.Ccount, inclgs2.Ccy, inclgs2.cLcy, inclgs2.cDate,
inclgs2.cTxn, inclgs2.cRef
FROM inclgs2
WHERE Trim(inclgs2.Ccy) = "" Or inclgs2.Ccy Is Null
--
Good Luck
BS"D

In the source table for the query below, Ccy is a numeric field and there are
a number of blank fields. I want the query to return only records where Ccy
is empty(I have tried "Isempty" "IsNull" "IsMissing" and the the result is
always the same, no records. Ther query I have tried is

SELECT inclgs2.Ccount, inclgs2.Ccy, inclgs2.cLcy, inclgs2.cDate,
inclgs2.cTxn, inclgs2.cRef
FROM inclgs2
WHERE (((inclgs2.Ccy)=IsMissing([Ccy])));

Any suggestions