Access
A family of Microsoft relational database management systems designed for ease of use.
395 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I seem to have problems when I try to Nest "Select Case(s)" in Access/SQL... Can it be done; is there a specific syntax to do it? This is what I am trying to accomplish...Select Case Me.[RecordSource]
Case 0
Case 1
Case 2
Select Case Me.[DataType]
Case X
Case Y
Case Z
End Select
Case 3
Case Else
End Select
No, that is not part of Access SQL. The reference is here: https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/microsoft-access-sql-reference
Next best thing is the IIf or Choose function.