Converting this expression to variable

[azhar2006]

Good morning youth
I have a question
Can I convert this expression to a variable in the VBA
In (SELECT [name] FROM [master] As Tmp GROUP BY [name] HAVING Count (*)> 1)
Thank you


Az

[azhar2006]

Thank teachers
I mean, how is written in the form of code VBA

[orange]

azhar2006,
Again we have trouble understanding your intent. Here is one example (air code - untested) of putting sql in a variable.
I doubt that this is what you are looking for.

'sample showing SQL in MyVariable
' Get info about Employees that do NOT have duplicate Name in Table Master
....
Dim myVariable as string
MyVariable = "In (SELECT [name] FROM [master] As Tmp GROUP BY [name] HAVING Count (*)> 1)"
Dim mySql as string
MySql = "SELECT EmployeeID, EmployeeNumber, EmployeeName, EmpEmail FROM MyTable " _
          & "WHERE  EmployeeName "
Dim db as DAO.Database
Dim rs  as DAO.Recordset
Set db = currentdb
set rs = db.OpenRecordset( MySql & "  NOT " & MyVariable)
With rs
Do While not .eof
     Debug.Print !EmployeeID & "  " & !EmployeeNumber & " " & EmployeeName & " " &EmployeeEmail
.Movenext
Loop
End With
......

[azhar2006]

Hello
Ha ha
I am very sorry Orange
Yes, this is what I want
Get info about Employees that do NOT have duplicate Name in Table Master
Thanks again