Need Access 2000/SQL help.
I'm trying to do inline queries in Access 2000.
I'm selecting all units that passed and failed, in this instance. My question is, how do I get the results to display? Anywhere would be fine, I just need them in a text box, a variable, anything at all.
Private Sub Command145_Click() Dim conDatabase As ADODB.Connection Dim strSQL As String Set conDatabase = CurrentProject.Connection strSQL = "SELECT tblXD.[Pass/Fail] FROM tblXD" conDatabase.Execute strSQL conDatabase.Close Set conDatabase = Nothing End Sub
I'm selecting all units that passed and failed, in this instance. My question is, how do I get the results to display? Anywhere would be fine, I just need them in a text box, a variable, anything at all.