Report with 3 criteria

[BFlat]

I am trying to open a report base on 3 criteria as follows:


DoCmd.OpenReport "rpt_sumReadmissionDate", acViewPreview, , ("[Source]<>' Non-Collaborative Facility' And [CurrentAdmit]-[DischargeDate]>2 And [Home]<>'Yes'")

The first two criteria work fine but when I added the third criteria hundreds of records dropped form the report although majority of the records in the database meet all three criteria.

I'm not sure what I am doing wrong of if access allows for 3 criteria. PLEASE HELP

[dbdesign]

Perhaps you can put that criteria right in the query that runs the report instead? If you have different criteria for different situations, use the RecordSource

If Whatever Then
DoCmd.OpenReport "rpt_sumReadmissionDate", acViewPreview
Me.RecordSource="Query1"
Else
DoCmd.OpenReport "rpt_sumReadmissionDate", acViewPreview
Me.RecordSource="Query2"
End If

[JoeM]

Do you have any NULL fields in your [Home] field? That often messes with criteria and you need to explicitly account for it, i.e.

...And ([Home]<>'Yes' Or Is Null"))

[BFlat]

Cheers! I did have some null fields. Thanks for your help.