I found we have inactivated some patients early in our use of Open Dental but did not pull their physical files from active file cabinet. I need to create a query that will list inactive patients by date they were inactivated along with their first and last name. So we can then pull the ones that we need to from 2006-2007.
Thanks
Need simple query help
Re: Need simple query help
The main problem is finding a unique and reliable time stamp for inactivation in the database for the time period you mentioned, since I don't think changing status to "inactive" created one.
DMA, Inc.
http://www.dmatechsolutions.com
http://www.dmatechsolutions.com
Re: Need simple query help
Does anyone else have any ideas? I would really appreciate any help with this one.
Thanks
Thanks
Re: Need simple query help
I'm not sure but I think this one can't be done because I believe OD doesn't set a date for when a patient is inactivated. I could be wrong. Maybe Jordan can clarify this.
Jorge Bonilla, DMD
Jorge Bonilla, DMD
Jorge Bonilla DMD
Open Dental user since May 2005
Open Dental user since May 2005