Criteria won't work

[geoffcodd]

I have the following criteria in a query but can'y seem to get it right

IIf([Forms]![Report_Criteria_Selection]![Type_Selection]=19,[Date_TaxPoint]) Between DateAdd("d",25,[Forms]![Report_Criteria_Selection]![Start_Date]), [Present_Date] Between DateAdd("d",25,[Forms]![Report_Criteria_Selection]![Start_Date])

So if someone selects type 19, then TaxPoint will be filtered, otherwise the Present Date will be filtered

Any help appreciated

Thanks
Geoff

 

[Mile-O]

Look closely at it:

i)

IIf([Forms]![Report_Criteria_Selection]![Type_Selection]=19,[Date_TaxPoint])

What's the bracket doing after [Date_taxPoint] ?

ii)

Between DateAdd("d" ,25,[Forms]![Report_Criteria_Selection]![Start_Date])

Between that and what?

iii)

[Present_Date] Between DateAdd("d" ,25,[Forms]![Report_Criteria_Selection]![Start_Date])

Again, where [Present_Date] is between [Start_Date] + 25 and what?


The expression you want will follow this structure:

IIf( condition/expression, Between A and B, Between A and B)

 

[geoffcodd]

Thanks

I don't know whats wrong with me today, I've just gone thick

Thanks
Geoff