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
Vendor list
Sep 19, 2007
2 Replies
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
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required