Hello I'm trying to open a report only if fields age>=50 , gender = male , language = french and type this :
If Me.Age >= 50 Then DoCmd.OpenReport " Rpt1", acViewPreview
If Me.Gender = Male Then DoCmd.OpenReport "Rpt1", acViewPreview
If Me.language= french DoCmd.OpenReport "Rpt1" , acViewPreview
The report is open with only one condition , but I need it with three conditions. Should I use AND ?
Thank you very much.
If Me.Age >= 50 Then DoCmd.OpenReport " Rpt1", acViewPreview
If Me.Gender = Male Then DoCmd.OpenReport "Rpt1", acViewPreview
If Me.language= french DoCmd.OpenReport "Rpt1" , acViewPreview
The report is open with only one condition , but I need it with three conditions. Should I use AND ?
Thank you very much.