Need Help with a formula in a query!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

debbiep@ywcaofjamestown.com - 29 Sep 2007 20:37 GMT

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))

Reply to this Message

debbiep@ywcaofjamestown.com - 29 Sep 2007 20:55 GMT

On Sep 29, 3:37 pm, "debb...@ywcaofjamestown.com"
<debb...@ywcaofjamestown.com> wrote:

> I am working in a query. I have a field called DOB and a field called
> Classroom. I am trying to come
[quoted text clipped - 15 lines]
> =
> "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.

Reply to this Message