Page 1 of 1
Printing my Insurance Carriers list
Posted: Sat Mar 23, 2019 10:07 am
by 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?
Re: Printing my Insurance Carriers list
Posted: Sat Mar 23, 2019 12:13 pm
by Tom Zaccaria
Try this,
drtmz
select CarrierName, Address, Address2, City, State, Zip, Phone, ElectID
from carrier
Re: Printing my Insurance Carriers list
Posted: Sat Mar 23, 2019 1:34 pm
by 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.
Re: Printing my Insurance Carriers list
Posted: Sun Mar 24, 2019 7:37 am
by Tom Zaccaria
There is:
Main Menu, Lists, Insurance Carriers
drtmz
Re: Printing my Insurance Carriers list
Posted: Sun Mar 24, 2019 9:45 am
by jonesdds12
Yes, but can't print it. Or can I some way(and not screen shots)
Re: Printing my Insurance Carriers list
Posted: Mon Mar 25, 2019 2:53 am
by 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
Re: Printing my Insurance Carriers list
Posted: Mon Mar 25, 2019 4:27 am
by Jorgebon
Does this work for you?
select CarrierName, Address, Address2, City, State, Zip, Phone, ElectID
from carrier where IsHidden = 0 order by CarrierName
Re: Printing my Insurance Carriers list
Posted: Wed Mar 27, 2019 2:25 pm
by irfan
select CarrierName, Address, Address2, City, State, Zip, Phone, ElectID
from carrier
order by carriername asc