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
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
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:
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
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.