i have error in my data report when i click the command1 it says
"Data Field 'datess' not found" but i have that in my database and in my datareport

here's the code
Code:
Private Sub Command1_Click()
Dim rs As New ADODB.Recordset
Dim myquery As String

    myquery = "select code,(datess+', '+lname+' '+fname) as name, addr" & _
    " from info;"
    rs.Open myquery, CN, adOpenStatic
If rs.RecordCount > 0 Then
    Set DataReport1.DataSource = rs
    DataReport1.Show
End If
End Sub