Help Using If Statement

[JCS]

Hello Everyone,

To begin with I am using Access 2003. In a report I have a text box in
which I want to put the following IF statement (the IF statement is based on
the Date of Birth (DOB) field):
If the month and day of the DOB is > than 6/31 and less then 11/1 then
"November" else "". As always, you suggestions/help are greatly appreciated.

Regards,
John

 

[BruceM]

One possibility:

IIf(Month([DOB]) > 6 And Month([DOB]) < 11,"November","")

 

[Douglas J. Steele]

=IIf(Format(DOB. "mmdd") >= "0631" AND Format(DOB. "mmdd") <= "1101",
"November", "")

 

[JCS]

Gentlemen,

I tried both solutions and both solutions worked as I hoped they would.
Thank you for your prompt responses. I will press the Yes button for the
"Was this post helpful to you?" Again, many thnaks!!

John