Have a Microsoft Access query through a tableAdapter. Need results of that query to show up in a textbox on a form


  • Right now my form has a DataGridView linked to "JobRoofDataGrid" table. I created a query in the builder to count the items in column "PL" WHERE (JobID = ?). On my form, my datagridview shows only those items that have the same JobID number. That is what I want. But now I have a textbox that I need to fill with the COUNT of "PL". My query "SELECT COUNT(PL) AS TotalPL FROM JobRoofDataGrid WHERE (JobID=?) works when I Execute Query in the builder. How do I get "TotalPL" to a textbox?
    Wednesday, January 27, 2010 4:05 PM


  • Wrong Forum;this forum is for Windows Live Writer... perhaps you need a development forum.

    Hope this helps.
    • Marked as answer by MS_Rider Thursday, January 28, 2010 10:30 PM
    Thursday, January 28, 2010 1:48 AM