select case statements in VBA

  • Thread starter Thread starter dave
  • Start date Start date
D

dave

Does anyone know what the SQL Server 2000 equivalent, if
there is any, would be to the Access VBA Select Case
statement? For example code in VBA would be.

Dim SomeVariable As Integer

Select Case SomeVariable
Case 1
'Do this
Case 2
'Do that
Case Else
'Do all
End Select

Thanks, Dave
 
The place to ask a question about T-SQL would be in an SQL Server newsgroup,
not one about DAO and VBA in Microsoft Access. There are a number of
sponsored (look for them at "news.microsoft.com") and USENET newsgroups
devoted to SQL Server.

Larry Linson
Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

select case statement in vba 3
select case like? 8
WHERE statement in VBA 6
Select Case in VBA? 2
Public Functions in SQL statements... 4
Example Of VBA SQL Statement 0
vba doesn't trap errors? 1
Print dependent on Select Case value 3

Back
Top