Switch Function in Query Expression

[Drand]

Hi All

I am trying to use the switch function in a query.

The function I have created is:

YTDBud: Switch(Month(Date())=1,[sumofJan]),(Month(Date()) =2,[sumofJan]+[SumofFeb]

Where SumofJan and SumofFeb are fields in the query.

YTDBud: Switch(Month(Date())=1 returns the correct value for SumofJan but when I add the second expression I get an error message

"the expression you entered contains invalid sysntax,or you need to enclose your text data in quotes"

Is it possible to use the switch function the way I am attempting, and if so, what is the issue with my syntax?

Really appreciate your assistance.

 

[theDBguy]

You need to move the closing parens to the very end.

From ... [sumofJan]),

To ... + [SomOfFeb])

Hope that helps...

 

[arnelgp]

you can simply use Choose() function instead:

YTDBud: Choose(Month(Date()), [sumOfJan], [sumOfJan]+[sumOfFeb])

Choose function (Visual Basic for Applications) | Microsoft Docs

 

[Drand]

Thanks both for your responses. Both of which will work as I need it.

I was not aware of the choose function. This is far simpler than what I was attempting.

Again, many thanks

 

[theDBguy]

Thanks both for your responses. Both of which will work as I need it.

I was not aware of the choose function. This is far simpler than what I was attempting.

Again, many thanks

Glad we could assist. Good luck with your project.

 

[isladogs]

For info, the Switch function cannot be used in a query unless it is used within a wrapper function.
For more info, see https://www.devhut.net/access-using-split-in-a-query/

The Choose function can indeed provide a simple alternative for some situations such as this.

 

[arnelgp]

For info, the Switch function cannot be used in a query unless it is used within a wrapper function.

i think this is wrong info. You can of course use Switch() inside a Query. Maybe you have mistaken it with Split function.

 

[isladogs]

Oops. I need new glasses. I did indeed mean the Split function. Thanks