Multiple critera in Where Condition 2

[TimTDP]

In Access 2000 I want to filter the data for a report by Company and a specific date. This I can do. However I also want to include all records if the date field is empty.

The data field is called EDA

I have tried the following:

Wclause = "OrganisationId = " & OrgId & _
" and EDA >= #" & Format$(ReportFromDate, "yyyy-mm-dd") & "#" & _
" or IsNull(EDA)"

Where is the error?

 

[Remou]

The error is in IsNull, it should be:

EDA Is Null

 

[TimTDP]

Thanks

I still get two OrganisationId's in the result.
In the result I want only 1 OrganisationId, and all the records where EDA matches the date criteria and all records where EDA Is Null

 

[IGPCS]

do you mean that you want to get results only for that orginisationid ?

 

[randy700]

How about...

Wclause = "OrganisationId = " & OrgId & _
" and [COLOR=red]([/color]EDA >= #" & Format$(ReportFromDate, "yyyy-mm-dd") & "#" & _
" or [COLOR=red]EDA Is Null)[/color]"

Randy