Need Help with a formula

[debbiep]

I am working in a form. I have a field called Visiting Date and a
field called DOB and a field called Classroom. I am trying to come
up
with a formula in the Visiting date that will show if a Child's
Classroom = Bumble Bears, the visiting date needs to tell me the date
on his 15 months, when the Child's Classroom = Doodlebugs, the
visiting date needs to tell me the date on his 33 months.
I am looking for a formula to put into a bound text.
Can anyone help me. I have such a hard time with IF statements. Your
help is
greatly appreciated.
Thank you!

 

[Rick Brandt]

I am working in a form. I have a field called Visiting Date and a
field called DOB and a field called Classroom. I am trying to come
up
with a formula in the Visiting date that will show if a Child's
Classroom = Bumble Bears, the visiting date needs to tell me the date
on his 15 months, when the Child's Classroom = Doodlebugs, the
visiting date needs to tell me the date on his 33 months.
I am looking for a formula to put into a bound text.
Can anyone help me. I have such a hard time with IF statements. Your
help is
greatly appreciated.
Thank you!

=Switch(Classroom = "Bumble Bears", DateAdd("m", 15, DOB), Classroom =
"Doodlebugs", DateAdd("m", 33, DOB))

 

[debbiep]

=Switch(Classroom = "Bumble Bears", DateAdd("m", 15, DOB), Classroom =
"Doodlebugs", DateAdd("m", 33, DOB))

Thank you so much. It works perfect.

 

[debbiep]

=Switch(Classroom = "Bumble Bears", DateAdd("m", 15, DOB), Classroom =
"Doodlebugs", DateAdd("m", 33, DOB))

Now How do i do a conditional formating when the visiting date is 15
months to 18 months for Bumble Bears and 33 to 36 months for
Doodlebugs.

 

[Rick Brandt]

Now How do i do a conditional formating when the visiting date is 15
months to 18 months for Bumble Bears and 33 to 36 months for
Doodlebugs.

Sorry, I have never used Conditional Formatting.

 

[Rob Parker]

Hi Debbie,

I notice that Rick can't assist with this bit. Maybe this will help.

I assume that you're wanting to apply the conditional formatting to your
Visitingdate control. To do so, select Conditional Formatting with that
control selected; set the Condition Is dropdown to Expression, and in the
expression field enter:
[Classroom] = "Bumble Bears"
Then set the formatting as desired for that condition.

Add another condition for the same control; set the expression to:
[Classroom] = "Doodlebugs"
and set the formatting for that condition.

You can have up to three separate conditions in this fashion.

HTH,

Rob

 

[dylan]

I am working in a form. I have a field called Visiting Date and a
field called DOB and a field called Classroom. I am trying to come
up
with a formula in the Visiting date that will show if a Child's
Classroom = Bumble Bears, the visiting date needs to tell me the date
on his 15 months, when the Child's Classroom = Doodlebugs, the
visiting date needs to tell me the date on his 33 months.
I am looking for a formula to put into a bound text.
Can anyone help me. I have such a hard time with IF statements. Your
help is
greatly appreciated.
Thank you!