Vendor list

Hi, I have searched and cannot find this, so if it's a duplicate I am sorry. I need to print a list of our suppliers with address, phone, web, e-mail and account number. Does anyone have this?

Thanks, George

Reply to
geokar
Loading thread data ...

Here is the SQL you will need ....

select id as 'Account', suppliername as 'Supplier', address1 as 'Address', address2 as 'Address (Cont)', city as 'City', state as 'State', zip as 'Zip', phonenumber as 'Phone', faxnumber as 'Fax', emailaddress as 'Email', webpageaddress as 'Web Site' from supplier order by id

"geokar" wrote:

Reply to
Luminox

Hi, I have searched and cannot find this, so if it's a duplicate I am sorry. I need to print a list of our suppliers with address, phone, web, e-mail and account number. Does anyone have this?

Thanks, George

Reply to
cptsoft

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.