Show null values

[rkaria]

Hi All

I have a report which users run again passtocredit dates.

How ever some dates are blank which are not showing on the report.

Does anyone know what I need to enter in the query to show all values whether they are blank or not

Thanks
R

 

[Brianwarnock]

You have not given us much to go on, but assume that you are filtering on dates older than 10 days so criteria is mydate < Date()-10 or mydate is null


Brian

 

[rkaria]

You have not given us much to go on, but assume that you are filtering on dates older than 10 days so criteria is mydate < Date()-10 or mydate is null


Brian

Hi Brian

Sorry for the lack of info.

The user enters to and from dates in a text box which corresponds to another field called passed to credit. This brings back all records between these 2 dates. Now some of these dates are left blank. I need these records to still show on the report whether the passedtocredit date field is blank or not.

I tried your coding but it did not make a difference
Thanks

At the moment the criteria is currently set to:
<>[Forms]![AMKReportFramework]![AMKDate1] And <>[Forms]![AMKReportFramework]![AMKDate2]
r

 

[Brianwarnock]

Now I really am puzzled.
Normally the criteria to obtain data between 2 dates would be

Between [Forms]![AMKReportFramework]![AMKDate1] And [Forms]![AMKReportFramework]![AMKDate2]

what I was saying is add, on the next line in the Design grid, Is Null or you could
(Between [Forms]![AMKReportFramework]![AMKDate1] And [Forms]![AMKReportFramework]![AMKDate2]) Or Is Null


Your criteria is saying all records not equal to both dates, which I would have thought was all records

Brian

 

[rkaria]

Now I really am puzzled.
Normally the criteria to obtain data between 2 dates would be

Between [Forms]![AMKReportFramework]![AMKDate1] And [Forms]![AMKReportFramework]![AMKDate2]

what I was saying is add, on the next line in the Design grid, Is Null or you could
(Between [Forms]![AMKReportFramework]![AMKDate1] And [Forms]![AMKReportFramework]![AMKDate2]) Or Is Null


Your criteria is saying all records not equal to both dates, which I would have thought was all records

Brian

Brian
you are my hero, "(Between [Forms]![AMKReportFramework]![AMKDate1] And [Forms]![AMKReportFramework]![AMKDate2]) Or Is Null
" worked a treat. perfect.

Thanks so much

 

[Brianwarnock]

Good, pleased we got that sorted.

Brian