omitting records with blank field

[puthenveetil]

Hi all,

I had a report which is based on a query . That query is based on a criteria.The query works fine. My question is that is there any method to avoid records in report if a specific field is blank.

example:

SELECT Institutions.*, Recipients.Rec_ID, Recipients.Spon_ID, Recipients.Intro_letter, Recipients.East_Letter, Recipients.Christ_Letter, Recipients.Progress, Recipients.Inst_Name, Recipients.Rec_First, Recipients.Rec_Middle, Recipients.Rec_Last, Recipients.dob, Recipients.Inst_typ, Recipients.Spon_name, Recipients.Thanks_letter, [Gifts] & "$" AS Expr1, Recipients.Gift_date
FROM Institutions INNER JOIN Recipients ON Institutions.InstID = Recipients.InstID
WHERE (((Institutions.InstID)=[Enter Institution ID]));

if the field [Gifts] is blank, i want to omitt that record in report.

is that possible.

Thanks in advance


Thanks

 

[IgorB]

SELECT Institutions.*, Recipients.Rec_ID, Recipients.Spon_ID, Recipients.Intro_letter, Recipients.East_Letter, Recipients.Christ_Letter, Recipients.Progress, Recipients.Inst_Name, Recipients.Rec_First, Recipients.Rec_Middle, Recipients.Rec_Last, Recipients.dob, Recipients.Inst_typ, Recipients.Spon_name, Recipients.Thanks_letter, [Gifts] & "$" AS Expr1, Recipients.Gift_date
FROM Institutions INNER JOIN Recipients ON Institutions.InstID = Recipients.InstID
WHERE Institutions.InstID=[Enter Institution ID] and [Gifts] is not null

 

[puthenveetil]

Hi Igor,

Thanks for the reply. It worked with style......


Thanks