Help Using If Statement

J

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
 
D

Douglas J. Steele

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help! I need to pull out all of the birthdays in a school term 3
Creating a calculated field using dates in a form 3
Expression/Formula Help 1
Looking for help eith VBA string manipulation 2
Sorting Birthdate by month-day instead of by month-day-year 6
Test if a date falls within a given range of dates in Excel? 6
SQL statement in form text control 2
Faulty Datediff (Access 2003) 2

Top