Iím using VB 6 as a front end to Access 03 database to populate the MSChart control.
I have a combobox for defect categories. I would like to populate the chart with a single category selected from the combobox.

Not sure what to put in place of the * as shown in the statement below. I would like to display the date (Weeks) and the category with the number of defects.
Private Sub CategoryView()
    '  Display the category of chart data
    Set cmd.ActiveConnection = cn
    cmd.CommandText = "SELECT * FROM tbliface WHERE [Weeks] = '" & cboCategory.Text & "'" _
    & " ORDER BY [Weeks]"
thanks for any help