Need Help with a formula in a query!

[debbiep]

I am working in a query. I have a field called DOB and a field called
Classroom. I am trying to come

up
with a formula that will calculate the Visiting date that I put in my form. The formula for the form does not work in the query. 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.

Can anyone help me. I have such a hard time with IF statements. Your
help is
greatly appreciated.
Thank you!

This is the formula in the form bound text, which is perfect for that.

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

 

[debbiep]

I am working in a query. I have a field called DOB and a field called
Classroom. I am trying to come



This is the formula in the form bound text, which is perfect for that.

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

I got it, thanks anyway. You guys are great though. I have learned so
much just by asking questions. I wish I knew more.