I only want it to return items with a NULL value in my field called "ReportReceived".

[jalb]

Hello,



I want this report to only pull the records that have no date in the ReportRecieved field.

I tried =IsNull([ReportReceived]), but that did not work.

Any assistance would be appreciated!

Thank you,
Kim
First time database builder!!

[pbaldy]

Where did you try that? I'd either use a query with a criteria of Is Null on that field or this technique:

BaldyWeb wherecondition

with a wherecondition of

"ReportReceived Is Null"

[jalb]

Hello,

Thanks for your response.

I built the report using the wizard.

I need to have the report as follows:

ReportDue - ItemNumber - Name - Vendor - ReportReceived
4/20/2012 - 1234 - Name - Vendor - Null Want to show on my report
4/10/2012 - 1234 - Name - Vendor - 4/11/2012 Do not want to show because the report is back

In the Design view of the report in the Textbox ReportRecived I tried to do the expression builder in the Conrol source section using the above =IsNull([ReportReceived])

Thank you
Kim

[pbaldy]

It's not doing you any good there. Try one of the methods I mentioned.

[RagJose]

Your approach is trying to filter the records from within a control in the report. It is too late then. Filtering must be done at the report level as pbaldy pointed. Then each record will be submitted to the filter before being (or not) formatted for output.