Well, I'm stumped again. I am still working with an Access Database. I query thus;
SELECT [Item #], SUM(Amount)
FROM Ledger
GROUP BY [Item #]
It returns the Item #, but no values. Yet when I build the query and test it, it returns the proper values. Have no other SQL to try.
The query above is FillByItemTotal. And here is the VB code.
Private Sub cmdYTD_Click(sender As Object, e As EventArgs) Handles cmdYTD.Click
Me.LedgerTableAdapter.FillByItemTotal(Me.QVGCFinanceDataSet1.Ledger)
End Sub
I can't find anything wrong with either the query or the code.
I am filling a DataGridView that has only 2 columns. One for the item # and the second for the amount. The load works fine, populating the DataGridView with 153 items and each value. The vb code above is triggered with a button. When it runs, it populates the first column with 41 discreet items. The second column, (Amount), is empty. This whole project uses only two lines of code. Plus two queries. I might have to kick this project down the road.
What I have tried:
Tried several different queries. They work OK in Query Builder, But no values are returned when I run the form.