I am using Access 2007(accdb) And ADODC in vb form.In a given date I have a lot of credit entries and Debit entries in text boxes. Is it possible to sum all credit entries and Debit entries an find the difference in a given date by using vb code? Is it also possible to see a particular day's entries by using sql in a Data Grid? how to filter a particular date in Data Grid?

Please help me

Why not do all the calculations are database level.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.