FlyingL0
06-09-2003, 07:38 AM
I have this SQL command that gets all my records based on a vendor name...
sqlString = "Select approved, vend_name, po_number, user, podate from finished WHERE vend_name like '%" & searchfor & "%'group by po_number, vend_name, user, podate, approved"
However in the approved colum there is a "Y" or a "N" I would only like to list the vendors with a "Y" How do I go about this?
sqlString = "Select approved, vend_name, po_number, user, podate from finished WHERE vend_name like '%" & searchfor & "%'group by po_number, vend_name, user, podate, approved"
However in the approved colum there is a "Y" or a "N" I would only like to list the vendors with a "Y" How do I go about this?