Iif Statement based on 2 conditions

[Thorson]

Is it possible to do an Iif statment in a query based on 2 conditions?

This is what I currently have (if dates are not in the same month put
correction otherwise null):

Correction:
IIf(Month([qryDSACMonthlyDispositionRecords]![EntryDate])<>([qryDSACMonthlyDispositionRecords]![Expr1]),"Correction",Null)

I would like to change it to If dates are in the same month and the day in
the date ([qryDSACMonthlyDispositionRecords]![EntryDate]) is 5 or less then
put correction otherwise put null.

How do I write this?

Thanks for the help!

 

[John Spencer]

Probably

IIf(Month([qryDSACMonthlyDispositionRecords]![EntryDate])<>[qryDSACMonthlyDispositionRecords]![Expr1]
AND Day([qryDSACMonthlyDispositionRecords]![EntryDate])<=5,"Correction",Null)

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Thorson]

Works Perfectly! Thank you!
--
Thorson

Probably

IIf(Month([qryDSACMonthlyDispositionRecords]![EntryDate])<>[qryDSACMonthlyDispositionRecords]![Expr1]
AND Day([qryDSACMonthlyDispositionRecords]![EntryDate])<=5,"Correction",Null)

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Is it possible to do an Iif statment in a query based on 2 conditions?

This is what I currently have (if dates are not in the same month put
correction otherwise null):

Correction:
IIf(Month([qryDSACMonthlyDispositionRecords]![EntryDate])<>([qryDSACMonthlyDispositionRecords]![Expr1]),"Correction",Null)

I would like to change it to If dates are in the same month and the day in
the date ([qryDSACMonthlyDispositionRecords]![EntryDate]) is 5 or less then
put correction otherwise put null.

How do I write this?

Thanks for the help!