Loop function

[vivian2u]

Example:

table: tblPayment
InvNo Cid Ino AmtPay DueDate
A001 001 1 1000.00 12/04/2005
A001 001 2 .00 24/04/2005
A001 001 3 .00 30/04/2005
A001 001 4 500.00 15/04/2005
A001 001 5 .00 18/04/2005

How do write the Loop function to select all the Ino where the AmtPay is 0 and display it on a MSFlexGrid1. Please help me in the coding.
Thanks.

[plenderj]

Your SQL Statement would be along these lines

SELECT * FROM tblPayment 
WHERE AmtPay = 0

Then it really depends on whether you're using DAO, ADO, ADO.NET etc. etc.