how to select non-empty cells in query.

[james]

Hi, All. Please help me..
When I do DRW in frontpage, I wrote the following custom
query in step 2. But, it is extracting all records
including NULL records in "Part_A" field. (Part field is
working for 'f' or 'p')

Please check my query command.

=========================================================
SELECT count(Part) as 'Part' FROM TableName Where Part
= 'f' or Part = 'p' and Part_A is not null;
=========================================================
As you notices, I'm trying to count the records in "Part"
field which contain F or P. But, the records in Part_A
field are not null.

Thanks in advance

James

 

[MD WebsUnlimited.com]

Hi James,

More precisely it is selecting records that have

Part = 'f' or ( Part = 'p' and Part_A is not null);

Change to
( Part = 'f' or Part = 'p' ) and Part_A is not null