Group by

[mnaem02]

How can i put group by in below code




Dim strsource As String




strsource = "SELECT UnitsMeasureTotal, UnitsMeasure " & _
"FROM InventoryProducts " & _
"WHERE UnitsMeasure = '" & UnitsMeasure & "'"





UnitsMeasureTotal.RowSource = strsource
UnitsMeasureTotal = vbNullString

[aytee111]

Create the query in query design, then copy and paste the SQL into VBA, making changes as required.