Share via

Microsoft Access - Where is the Switch function?

Anonymous
2022-01-27T04:55:52+00:00

I do not see "swift" function in the expression builder. it displays IIf only. How can I add swift to it?

I think I have the 2019 version.

Microsoft 365 and Office | Access | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2022-01-29T12:32:04+00:00

    Although the Switch function cannot be called in a calculated field in a table, it can in a calculated column in a query. Just one reason why a query should be used when a computed value is to be returned.

    1 person found this answer helpful.
    0 comments

13 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. DBG 11,531 Reputation points Volunteer Moderator
    2022-01-27T05:53:43+00:00

    I do not see "swift" function in the expression builder. it displays IIf only. How can I add swift to it?

    I think I have the 2019 version.

    Hi. What does "swift" do? Or, did you mean "switch?"

    0 comments
  2. ScottGem 68,780 Reputation points Volunteer Moderator
    2022-01-27T13:56:38+00:00

    I have never heard of a "swift" function in Access. Can you elaborate?

    0 comments
  3. Anonymous
    2022-01-28T04:40:22+00:00

    You are right, I meant "switch" not "swift".

    0 comments
  4. DBG 11,531 Reputation points Volunteer Moderator
    2022-01-28T05:29:00+00:00

    You are right, I meant "switch" not "swift".

    Which expression builder are you using? I see it below.

    0 comments