Need a query for unused benefits that also lists addresses

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
mzrdmd
Posts: 117
Joined: Tue Jun 26, 2007 8:28 pm
Location: Johnstown, PA

Need a query for unused benefits that also lists addresses

Post by mzrdmd »

Greetings, all !

I am in need of doing an unused benefits letter. I found a query that will do the report for me on the query examples page, #21. Only problem is that it does not list the addresses, just the First and Last names, amount used, amount remaining, amt tx planned.

It would be really nice if it would also list the address, so that I could do a mail merge and send them out without having to do everything manually.

Any help greatly appreciated.

Thanks,

Mike
Jordan Sparks ROCKS !
mzrdmd
Posts: 117
Joined: Tue Jun 26, 2007 8:28 pm
Location: Johnstown, PA

Post by mzrdmd »

Anyone ? Anyone ?

Thanks,

Mike
Jordan Sparks ROCKS !
User avatar
jordansparks
Site Admin
Posts: 5776
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Post by jordansparks »

I just altered query #21 to include address.
Jordan Sparks, DMD
http://www.opendental.com
mzrdmd
Posts: 117
Joined: Tue Jun 26, 2007 8:28 pm
Location: Johnstown, PA

Post by mzrdmd »

Thanks, Jordan !

You TOTALLY rock !

Mike
Jordan Sparks ROCKS !
Post Reply