# How to write code to retrieve data from access table

Posted by Ta-Jen Chung on February 01, 1999 at 14:14:08:

I have created a database named business.mdb in Access. Transaction is
one table in business.mdb and it contains some fields such as salesId,
ProductName, date, quantity and customerID.

How can I use vb to retrieve all transactions for each specific customer by using customerID as criteria? and How can I display the final result in DBgrid?

Thanks!

Follow Ups: