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 » Mon Aug 20, 2007 5:47 am

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 » Thu Aug 30, 2007 11:47 am

Anyone ? Anyone ?

Thanks,

Mike
Jordan Sparks ROCKS !

User avatar
jordansparks
Site Admin
Posts: 5742
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Post by jordansparks » Thu Aug 30, 2007 12:37 pm

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 » Tue Sep 04, 2007 9:40 am

Thanks, Jordan !

You TOTALLY rock !

Mike
Jordan Sparks ROCKS !

Post Reply