Report to show fields are blank 1

[Crystalamateur]

Hi there

I am trying to create a report that shows me a date/time field that is blank when another field has the Yes checked.

In my select expert I have said
Gift Aid equals 'Y'

I am looking to find all records were this field has a Yes checked, but no corresponding date. The Gift Aid Date is blank.

Any suggestions please

Thanks
Peter

 

[TheBlondOne]

You could put the following into the select expert aswell.

isnull({Gift Aid Date}) or {Gift Aid Date} = date(00,00,00)

HTH

-Steve


"if at first you don't succeed, sky diving is not for you"!!! )

 

[Crystalamateur]

Hi Steve

Many thanks it worked.

Cheers
Peter

 

[TheBlondOne]

Great.

-Steve


"if at first you don't succeed, sky diving is not for you"!!! )