tables in access
1.print the cars which are fast moving cars.
i have written this code but it shows message Cannot have aggregate function in expression
pl show me anyother way to solve this problem
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
da = New OleDbDataAdapter("select * from car where carno=(select carno from sales where sum(num)=(select max(sum(num)) from sales group by carno) group by carno)", cn)
DataGridView1.DataSource = ds.Tables(0)
End Sub [/code]