return blanks in query result ...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jer - 03 Aug 2006 23:35 GMT

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

Signature

thanks as always for the help
jer

Reply to this Message

Ofer Cohen - 03 Aug 2006 23:41 GMT

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

Signature

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
[quoted text clipped - 7 lines]
>
> Any suggestions

Reply to this Message

jer - 03 Aug 2006 23:48 GMT

Thank you Ofer

Signature

thanks as always for the help

> Try
>
[quoted text clipped - 20 lines]
> >
> > Any suggestions

Reply to this Message