Printing my Insurance Carriers list

[jonesdds12]

Is there no way to do this?

I'd want the carrier name, phone, address and ideally the electronic id. How can I do this?

[Tom Zaccaria]

Try this,
drtmz

select CarrierName, Address, Address2, City, State, Zip, Phone, ElectID
from carrier

[jonesdds12]

That worked ok but it's not a complete list, some are missing and it's in a very odd order. I was going to post the screenshot but no idea how to do that. Seems odd there's not a standard report to print this list.

[Tom Zaccaria]

There is:

Main Menu, Lists, Insurance Carriers

drtmz

[jonesdds12]

Yes, but can't print it. Or can I some way(and not screen shots)

[Tom Zaccaria]

Work around:
Make the window as large as you can by stretching it to the top and bottom of the screen. Then use screen shots.

drtmz

[Jorgebon]

Does this work for you?

select CarrierName, Address, Address2, City, State, Zip, Phone, ElectID
from carrier where IsHidden = 0 order by CarrierName

[irfan]

select CarrierName, Address, Address2, City, State, Zip, Phone, ElectID
from carrier
order by carriername asc