Search found 323 matches

by Tom Zaccaria
Fri Nov 05, 2021 5:14 am
Forum: Main Forum
Topic: Overdue Hygiene Query
Replies: 1
Views: 568

Re: Overdue Hygiene Query

Been using this forever. Change the procedure codes to search for whatever you want. Time interval is in days to search. drtmz /*264 List of procedures for a date range with patient name, service date, procedure code, primary insurance carrier, fee, sum of ins est, sum ins paid*/ /*Just change the i...
by Tom Zaccaria
Thu Oct 21, 2021 5:32 am
Forum: Main Forum
Topic: Query to compare insurance reimbursements by ADA code
Replies: 4
Views: 1457

Re: Query to compare insurance reimbursements by ADA code

To get rid of the procedures with no fee(s), procedures you do not do in your practice such as ortho, export the report to Excel. Data sort on the Standard column from low to high value. Then delete all the rows with zero Standard fees. Lastly, resort on ProcCode column to get your final report. drtmz
by Tom Zaccaria
Tue Oct 19, 2021 11:50 am
Forum: Main Forum
Topic: Query to compare insurance reimbursements by ADA code
Replies: 4
Views: 1457

Re: Query to compare insurance reimbursements by ADA code

Did a little fiddling with a list of Fee Schedules and their corresponding Plan Numbers and it works perfectly. Exactly what I was looking for.
Thanks again,

drtmz
by Tom Zaccaria
Tue Oct 19, 2021 10:48 am
Forum: Main Forum
Topic: Query to compare insurance reimbursements by ADA code
Replies: 4
Views: 1457

Re: Query to compare insurance reimbursements by ADA code

Thanks for your help.

drtmz
by Tom Zaccaria
Fri Oct 15, 2021 1:42 pm
Forum: Main Forum
Topic: Query to compare insurance reimbursements by ADA code
Replies: 4
Views: 1457

Query to compare insurance reimbursements by ADA code

Looking for a query to compare insurance plan reimbursement in a spreadsheet form for all or some of the ADA procedure codes such as: Insurance Plan...............Aetna......MetLife....Cigna......Delta Ada code....Description.....Fee.........Fee........Fee.........Fee It would be helpful if you coul...
by Tom Zaccaria
Thu Oct 07, 2021 8:37 am
Forum: Main Forum
Topic: A query/report
Replies: 3
Views: 1438

Re: A query/report

Does this help? Just change the recall type. You can reorganize the list by columns by clicking on the column heading. drtmz /*807 List of patients who have a specific insurance or specific employer, and their interval for recall.*/ SET @InsCarrier='%%'; /*Set to '%%' to include all carriers*/ SET @...
by Tom Zaccaria
Mon Aug 30, 2021 4:33 am
Forum: Main Forum
Topic: MYSQL to MariaDB conversion
Replies: 3
Views: 2213

MYSQL to MariaDB conversion

Anyone out there made the conversion from MYSQL to MariaDB that was not a new installation? I did it over the weekend on a backup machine. Uses the file on the installation page. Fairly straight forward. One minor glitch overall. Took about an hour. Unless they can somehow speedup the process or I a...
by Tom Zaccaria
Wed Jul 28, 2021 11:20 am
Forum: Main Forum
Topic: You know what would be really cool?
Replies: 3
Views: 2379

Re: You know what would be really cool?

It was modified from the query examples list. Plus,I like to be in the 'Cool' category.

drtmz
by Tom Zaccaria
Wed Jul 28, 2021 10:35 am
Forum: Main Forum
Topic: You know what would be really cool?
Replies: 3
Views: 2379

Re: You know what would be really cool?

This will list all the pans you took depending on the date range you put in. drtmz /*264 List of procedures for a date range with patient name, service date, procedure code, primary insurance carrier, fee, sum of ins est, sum ins paid*/ SET @FromDate='2021-1-01' , @ToDate=curdate(); /* change date h...
by Tom Zaccaria
Wed Jun 23, 2021 7:33 am
Forum: Advanced Topics
Topic: Message=Duplicate entry '4657089' for key 'PRIMARY'
Replies: 3
Views: 4732

Re: Message=Duplicate entry '4657089' for key 'PRIMARY'

That should work. I have found that this happens, error message, whenever I try to backup hot. That is when anybody is using OD. All users have to be signed out .Been happening for a long time. OD central hasn't been able to find a fix.
BTW I use xcopy for backups.

drtmz
by Tom Zaccaria
Mon Mar 29, 2021 4:34 pm
Forum: Advanced Topics
Topic: Appointment Mouse Over Info Customization
Replies: 3
Views: 5466

Re: Appointment Mouse Over Info Customization

Try

Main Menu / Display Fields / Appointment Bubble

drtmz
by Tom Zaccaria
Mon Mar 29, 2021 8:18 am
Forum: Main Forum
Topic: social security numbers
Replies: 2
Views: 4415

Re: social security numbers

Didn't think we could ever delete things in this version of mysql by design. Only hide. And that had to be done by OD central.

drtmz
by Tom Zaccaria
Sat Mar 20, 2021 12:25 pm
Forum: Main Forum
Topic: "Unhandled exception has occured in your application"
Replies: 3
Views: 3275

Re: "Unhandled exception has occured in your application"

You might try stopping and starting mysql service, On your server, R click on Home Select Computer Management Select Services and Applications Select Services Scroll down to mysql service Then stop and restart the mysql service Or a server reboot might get it going Then try the databaseintegrity fix...
by Tom Zaccaria
Sat Mar 20, 2021 2:49 am
Forum: Main Forum
Topic: "Unhandled exception has occured in your application"
Replies: 3
Views: 3275

Re: "Unhandled exception has occured in your application"

Try this.

Log on to your server as a regular user. Then go to the folder called Opendentimages\Updatefiles\Databaseintregitycheck.exe

Click on that exe file and let it run as is. No changes to that screen.

drtmz
by Tom Zaccaria
Thu Mar 18, 2021 7:10 am
Forum: Main Forum
Topic: Multiple Instances of OpenDental running on server
Replies: 8
Views: 5660

Re: Multiple Instances of OpenDental running on server

Fix seems to be working.
Thanks

drtmz
by Tom Zaccaria
Wed Mar 10, 2021 9:33 am
Forum: Main Forum
Topic: Multiple Instances of OpenDental running on server
Replies: 8
Views: 5660

Re: Multiple Instances of OpenDental running on server

Right. When checking in Task Manager there were multiple (4) copies running.

drtmz
by Tom Zaccaria
Wed Mar 10, 2021 5:47 am
Forum: Main Forum
Topic: Multiple Instances of OpenDental running on server
Replies: 8
Views: 5660

Multiple Instances of OpenDental running on server

Updated on Friday to version 20.5.31 because we were getting multiple copies of OD on our server. This issue was supposed to be fixed. Checked this AM and there were four copies of OD running. Is this still an unresolved issue?
Thanks,
drtmz
by Tom Zaccaria
Sat Jan 02, 2021 3:52 am
Forum: Main Forum
Topic: Problem printing forms and letters
Replies: 10
Views: 5213

Re: Problem printing forms and letters

OK. Makes sense. We will wait for the bug to be corrected.

drtmz
by Tom Zaccaria
Wed Dec 30, 2020 3:50 am
Forum: Main Forum
Topic: Problem printing forms and letters
Replies: 10
Views: 5213

Re: Problem printing forms and letters

They are all running the latest version of Windows 10 pro. Not much of an issue any more.
Thanks,

drtmz
by Tom Zaccaria
Mon Dec 28, 2020 6:02 am
Forum: Main Forum
Topic: Problem printing forms and letters
Replies: 10
Views: 5213

Re: Problem printing forms and letters

That seemed to help a lot.
Thanks
drtmz
by Tom Zaccaria
Tue Dec 22, 2020 7:01 am
Forum: Main Forum
Topic: Problem printing forms and letters
Replies: 10
Views: 5213

Re: Problem printing forms and letters

Microsoft Zoom is turned off on all work stations.

drtmz
by Tom Zaccaria
Sun Dec 20, 2020 3:52 am
Forum: Main Forum
Topic: Problem printing forms and letters
Replies: 10
Views: 5213

Re: Problem printing forms and letters

Yes. I tried adjusting the Zoom but it didn't help. The display resolution in Windows is set to 'recommended'.
It is happening on laptops not the desktops. We have some of each.

drtmz
by Tom Zaccaria
Fri Dec 18, 2020 6:33 am
Forum: Main Forum
Topic: Problem printing forms and letters
Replies: 10
Views: 5213

Problem printing forms and letters

Looks like all our forms and letters on some of our work stations, laptops, are printing in 6 or 7 (very small) cpi since updating to version 20.4.28.
Any ideas? Fixes? Bug?
Thanks

drtmz
by Tom Zaccaria
Thu Dec 17, 2020 12:11 pm
Forum: Main Forum
Topic: Report: patients by a specific code
Replies: 2
Views: 1577

Re: Report: patients by a specific code

Try this. Change the procedure code in the fourth line from the bottom to search whatever code you want and the date range where indicated. /*264 List of procedures for a date range with patient name, service date, procedure code, primary insurance carrier, fee, sum of ins est, sum ins paid*/ SET @F...
by Tom Zaccaria
Sat Dec 05, 2020 3:50 am
Forum: Main Forum
Topic: Custom Sheet
Replies: 4
Views: 2579

Re: Custom Sheet

Send a copy of it my way and I will see if I can help you out.

drtmz
tmzdds@gmail.com
by Tom Zaccaria
Tue Oct 27, 2020 3:04 pm
Forum: Main Forum
Topic: TEMPERATURE LOG
Replies: 5
Views: 3112

Re: TEMPERATURE LOG

You have to know the FieldName you are using to store the temperatures. Run this query SELECT * from Apptfield limit 50 This will give you the FieldName and the value in it. For example, the FieldName might be Temperature and the Fieldvalue(s) 97.5, 98.0 etc. Once you have the proper name the query ...
by Tom Zaccaria
Thu Oct 22, 2020 4:18 am
Forum: Main Forum
Topic: TEMPERATURE LOG
Replies: 5
Views: 3112

Re: TEMPERATURE LOG

Nice evening's work.
Thanks,

drtmz
by Tom Zaccaria
Thu Sep 17, 2020 2:32 am
Forum: Main Forum
Topic: Issue with Forms and Letters
Replies: 3
Views: 2403

Re: Issue with Forms and Letters

Yes it was. Thank you.
drtmz
by Tom Zaccaria
Tue Sep 08, 2020 6:35 am
Forum: Main Forum
Topic: PDF Hell - Acrobat DC not a solution
Replies: 5
Views: 3395

Re: PDF Hell - Acrobat DC not a solution

Try Foxit free version. My IT guys are gravitating towart it.

drtmz
by Tom Zaccaria
Wed Aug 19, 2020 7:20 am
Forum: Main Forum
Topic: learning sql
Replies: 2
Views: 1911

Re: learning sql

Hi Sam,
You may want to start with the tutorials on Youtube. Then look at the query examples on OD website
Note - you won't be able to change any of the tables as described on YT but they are great for query writing.

drtmz
by Tom Zaccaria
Thu Aug 13, 2020 5:43 am
Forum: Main Forum
Topic: Issue with Forms and Letters
Replies: 3
Views: 2403

Issue with Forms and Letters

Anyone notice that when you select Forms or Letters, Forms or Letters Add, the form or letter selected is too big for the screen. They have to be dragged up to view the entire form? Is this a preview of the upcoming changes in zooming ability ? or a bug in Version 20.3.13? Hasn't been a issue in pre...
by Tom Zaccaria
Mon Aug 03, 2020 2:32 am
Forum: Main Forum
Topic: Unearned Income
Replies: 2
Views: 2000

Re: Unearned Income

Here is the work around
Reports, Standard, More Options, Uncheck Include Unearned

drtmz
by Tom Zaccaria
Wed Jul 29, 2020 5:09 am
Forum: Main Forum
Topic: Mass Email and Queries
Replies: 1
Views: 1678

Mass Email and Queries

Any plans to be able to import any Queries generated in OpenDental into the Mass Email screen? It would seem that this would increase the functionality of the Email option without any additional programming. For example, if you wanted to send a note to all the patients that are due for a Pan at thei...
by Tom Zaccaria
Mon Jul 20, 2020 8:36 am
Forum: Main Forum
Topic: Report of procedures by year with patient names
Replies: 1
Views: 1486

Re: Report of procedures by year with patient names

Try this but substitute the date you want and the procedure codes. /*264 List of procedures for a date range with patient name, service date, procedure code, primary insurance carrier, fee, sum of ins est, sum ins paid*/ SET @FromDate='2019-1-01' , @ToDate='2019-1-30'; /* change date here, change li...
by Tom Zaccaria
Tue Jul 14, 2020 1:04 pm
Forum: Main Forum
Topic: Breaks between appointments
Replies: 1
Views: 1787

Re: Breaks between appointments

To the best of my knowledge they backed off of that edict soon after it was declared. No need to wait.

drtmz
by Tom Zaccaria
Thu Jun 18, 2020 5:01 am
Forum: Main Forum
Topic: A/R (filters) query
Replies: 4
Views: 2798

Re: A/R (filters) query

Part of my problem is I do not have your situation to check the query. Our accounts are up to date. You always want to test run a query before using it live. I can play around with the paysplit table a little and see what might work.
Or a quick shout out to support may help.

drtmz
by Tom Zaccaria
Tue Jun 16, 2020 8:34 am
Forum: Main Forum
Topic: A/R (filters) query
Replies: 4
Views: 2798

Re: A/R (filters) query

This one might be better for your situation. drtmz /*6*/ SELECT CONCAT(LName,', ',FName,' ',MiddleI) ,Bal_0_30,Bal_31_60,Bal_61_90,BalOver90 ,BalTotal,InsEst,BalTotal-InsEst AS $pat, DATE_FORMAT(MAX(paysplit.ProcDate),'%m/%d/%Y') AS lastPayment FROM patient LEFT JOIN paysplit ON paysplit.PatNum=pati...
by Tom Zaccaria
Tue Jun 16, 2020 7:46 am
Forum: Main Forum
Topic: A/R (filters) query
Replies: 4
Views: 2798

Re: A/R (filters) query

Does this help your situation? drtmz /*590 List of Patients with balance over 90 days AND Billing Type is "Bad Debt-Sent to collections". Includes Patients Name, Patient Address, Phone Numbers, SSN, DOB, Patnum, Last Date of Service, Date of Last Payment, Last Amount Paid, Balance Due Amount*/ SELEC...
by Tom Zaccaria
Wed Jun 10, 2020 8:21 am
Forum: Main Forum
Topic: NP Query/Report
Replies: 3
Views: 2511

Re: NP Query/Report

I think this is what you are after. It is currently set for 2020. We use it all the time. drtmz /*Annual new patient count by Carrier broken down by month */ /*Query code written/modified: 08/11/2016*/ SET @Year='2020'; /*choose year, use 4 digits - i.e. 'yyyy' */ SELECT IFNULL(ca.CarrierName,'NONE'...
by Tom Zaccaria
Tue Apr 14, 2020 3:05 am
Forum: Main Forum
Topic: User query help
Replies: 8
Views: 5500

Re: User query help

It does as written, PatStatus=0, is code for active patients.

Now you may have entry errors in that an archived patient is still coded as active. But the report will return only those patients that are listed as active.

drtmz
by Tom Zaccaria
Sat Apr 11, 2020 4:59 am
Forum: Main Forum
Topic: User query help
Replies: 8
Views: 5500

Re: User query help

Ok. Here is the same code modified for both sexes grouped by age. I think this is what you want. /*175 Patients of specified age range and gender*/ SET @Young='1', @Old='100'; #Change age range here. SET @pos=0; SELECT @pos:=@pos+1 AS 'Count', PatNum, (YEAR(CURDATE())-YEAR(Birthdate)) - (RIGHT(CURDA...
by Tom Zaccaria
Sat Apr 11, 2020 4:49 am
Forum: Main Forum
Topic: User query help
Replies: 8
Views: 5500

Re: User query help

Do do know that will only give one specific gender. You would have to run it once for males and again for females. If you want to remove the gender variable, let me know. And I think we can group it by age.

drtmz
by Tom Zaccaria
Thu Apr 09, 2020 2:28 pm
Forum: Main Forum
Topic: User query help
Replies: 8
Views: 5500

Re: User query help

This should do it. If you want work phone, it is easy to add /*175 Patients of specifed age range and gender*/ SET @Young='1', @Old='100'; #Change age range here. SET @Gender='1'; #Change gender here. 0-Male, 1-Female, 2-Unknown SET @pos=0; SELECT @pos:=@pos+1 AS 'Count', PatNum, (YEAR(CURDATE())-YE...
by Tom Zaccaria
Tue Apr 07, 2020 2:59 am
Forum: Main Forum
Topic: User query help
Replies: 8
Views: 5500

Re: User query help

Post the code you have so far and I will see what help to offer you.

drtmz
by Tom Zaccaria
Tue Mar 10, 2020 3:57 am
Forum: Main Forum
Topic: Tooth Chart Updating
Replies: 2
Views: 3829

Re: Tooth Chart Updating

Adjust the graphics on that workstation as detailed here...

https://www.opendental.com/manual/graphics.html

drtmz
by Tom Zaccaria
Mon Feb 17, 2020 6:16 am
Forum: Main Forum
Topic: Creating of Sheets
Replies: 2
Views: 4264

Re: Creating of Sheets

Not knowing your situation I would have to say that your will have to setup all your custom forms. Use what OD gives you as defaults and modify or create from that point. Look at it this way, once you create all the forms you can use them forever. That's what we did 12 years ago and still use the sa...
by Tom Zaccaria
Mon Feb 10, 2020 8:00 am
Forum: Main Forum
Topic: Adjustment types
Replies: 3
Views: 4662

Re: Adjustment types

Actually the following query works better.

SELECT * FROM definition

Switch to Raw View and look at DefNum and ItemName columns.

drtmz
by Tom Zaccaria
Thu Feb 06, 2020 12:49 pm
Forum: Main Forum
Topic: Adjustment types
Replies: 3
Views: 4662

Re: Adjustment types

Thank you

drtmz
by Tom Zaccaria
Thu Feb 06, 2020 8:59 am
Forum: Main Forum
Topic: Adjustment types
Replies: 3
Views: 4662

Adjustment types

Is there a way to see the AdjTypes in the Adjustment table without having to switch between raw and human readable windows?
Basically, I want to know what each generated AdjNum refers to in plain English as in #10 = 10% cash discount when I query this table.

Thanks,
drtmz
by Tom Zaccaria
Sun Jan 26, 2020 7:01 am
Forum: Main Forum
Topic: Query
Replies: 1
Views: 3585

Re: Query

You could probably get numbers from this query:
#1451 Percentage of total patients seen in the specified date range by insurance carrier, including not insured -

Just need the total patient visits for the time period in question. This can be calculated.

drtmz
by Tom Zaccaria
Fri Nov 01, 2019 12:03 pm
Forum: Main Forum
Topic: Error in home backup
Replies: 7
Views: 7385

Re: Error in home backup

Cmcgehee,

Just copied a new version of C:\Program Files (x86)\Open Dental\DataConnectionBase.dll to my home computer and it worked like a charm. Back in business.
Thanks for the input.

drtmz
by Tom Zaccaria
Fri Nov 01, 2019 2:35 am
Forum: Main Forum
Topic: Error in home backup
Replies: 7
Views: 7385

Re: Error in home backup

C:\Program Files (x86)\Open Dental\DataConnectionBase.dll V 1.0.0.0

C:\Program Files (x86)\Open Dental\OpenDental.exe V19.3.15.0

Should I just copy the .dll file from office to home?

drtmz
by Tom Zaccaria
Thu Oct 31, 2019 1:08 pm
Forum: Main Forum
Topic: Error in home backup
Replies: 7
Views: 7385

Re: Error in home backup

Tried that twice. Deleted Opendental data but not OD Images. No luck. I will delete everything, do a clean install and go from there.
Very frustrating.

drtmz
by Tom Zaccaria
Thu Oct 31, 2019 7:39 am
Forum: Main Forum
Topic: Error in home backup
Replies: 7
Views: 7385

Re: Error in home backup

No, I do not.
I did upgrade from 19.2.35 to 19.3.9 at home and the office . Discovered 19.3.9 was too buggy. Decided to go back and install 19.2.35 or one of those versions, at home. That is when the error occurs.
We still have 19.3.9 at the office.

drtmz
by Tom Zaccaria
Wed Oct 30, 2019 6:43 pm
Forum: Main Forum
Topic: Error in home backup
Replies: 7
Views: 7385

Error in home backup

Been trying to restore 19.3.9 to home computer. Got this error Unhandled exception: Field not found: 'DataConnectionBase.DataConnection.DataReaderNullTimeoutSeconds'. System.MissingFieldException at OpenDental.FormOpenDental.FormOpenDental_Load(Object sender, EventArgs e) at System.EventHandler.Invo...
by Tom Zaccaria
Tue Oct 29, 2019 12:58 pm
Forum: Main Forum
Topic: Much more efficient way of charting
Replies: 17
Views: 17264

Re: Much more efficient way of charting

That seems to be what I have read in several places. Thanks for clearing it up.

drtmz
by Tom Zaccaria
Mon Oct 28, 2019 1:58 pm
Forum: Main Forum
Topic: Much more efficient way of charting
Replies: 17
Views: 17264

Re: Much more efficient way of charting

Correct me if I am wrong but doesn't scripting like this pose a security risk?
I may have read something somewhere to that effect.

drtmz
by Tom Zaccaria
Wed Oct 23, 2019 10:46 am
Forum: Main Forum
Topic: Update taking a long time (getting longer)
Replies: 3
Views: 4225

Re: Update taking a long time (getting longer)

I do understand it is the backup that is the problem. I will call in next time we update.
Thanks for the reply

drtmz
by Tom Zaccaria
Wed Oct 09, 2019 4:39 am
Forum: Main Forum
Topic: Update taking a long time (getting longer)
Replies: 3
Views: 4225

Update taking a long time (getting longer)

Seems it is taking longer and longer to update versions of OpenDental. Then I found this: "Usually Open Dental will automatically backup the database during an update as a preventive measure. Large enterprise organizations that update often and have a comprehensive backup strategy can contact Open D...
by Tom Zaccaria
Wed Oct 02, 2019 6:48 am
Forum: Main Forum
Topic: Landscape vs Portrait
Replies: 4
Views: 4540

Re: Landscape vs Portrait

Had this issue! If you include the unearned income column in the report it will print in landscape b/c there are too many columns for portrait. Trick is to unselect this option and then you will be back to portrait view.

drtmz
by Tom Zaccaria
Mon Sep 30, 2019 4:49 am
Forum: Main Forum
Topic: Problems with Dexis bridge.
Replies: 3
Views: 4852

Re: Problems with Dexis bridge.

I see you have a compatibility tab as a choice. in VixWin when this happens with an update we select the Compatibility and change the selection to Windows 7.
This may or may not be your problem.

drtmz
by Tom Zaccaria
Thu Sep 19, 2019 6:16 am
Forum: Main Forum
Topic: Scheduling Template
Replies: 1
Views: 2098

Re: Scheduling Template

Have you reviewed this page?
https://www.opendental.com/manual/schedule.html
It takes some time but once the template is set up you can copy by day or week.
drtmz
by Tom Zaccaria
Sun Jun 30, 2019 4:29 am
Forum: Main Forum
Topic: cannot find or create the font. on statement PDFs
Replies: 2
Views: 2334

Re: cannot find or create the font. on statement PDFs

1. Check that you have the proper printer selected.
2. What are you using to view PDF files? We use Acrobat Reader DC. It's free.

drtmz
by Tom Zaccaria
Sun Jun 16, 2019 4:26 am
Forum: Main Forum
Topic: Patient Dashboard - 19.1 Version
Replies: 5
Views: 5172

Re: Patient Dashboard - 19.1 Version

Agree. Been playing around with 19.1 at home. If I implemented it in the office, the front desk would kill me. We have eight columns showing in the appointment module. The dashboard seriously reduces the column width of each provider.

I know OD will fix this.

drtmz
by Tom Zaccaria
Thu Jun 13, 2019 3:05 am
Forum: Main Forum
Topic: Help finding report
Replies: 2
Views: 2336

Re: Help finding report

Try this. drtmz /*449 List of active patients (not subscribers) with primary insurance plan listed, Carrier Names and group names are cutoff for space consideration Check RAW button to show both PatNum and Patient Name*/ SELECT IFNULL(Left(c.CarrierName, 15), 'None') AS CarrierName, Left(GroupName, ...
by Tom Zaccaria
Thu May 16, 2019 8:41 am
Forum: Main Forum
Topic: Query Help!!
Replies: 5
Views: 3990

Re: Query Help!!

The simplest solution may be to export the query to an excel spreadsheet and then just highlight and print the rows you want.

drtmz
by Tom Zaccaria
Tue May 14, 2019 1:47 pm
Forum: Main Forum
Topic: Query Help!!
Replies: 5
Views: 3990

Re: Query Help!!

try changing the last line to

ORDER by status;

drtmz
by Tom Zaccaria
Mon Apr 08, 2019 2:22 pm
Forum: Main Forum
Topic: Add recall type to default list of recalls for new patients.
Replies: 3
Views: 3254

Re: Add recall type to default list of recalls for new patie

See my post. That is how you setup new recalls.

drtmz
by Tom Zaccaria
Thu Apr 04, 2019 5:11 pm
Forum: Main Forum
Topic: Add recall type to default list of recalls for new patients.
Replies: 3
Views: 3254

Re: Add recall type to default list of recalls for new patie

Main Menu, click Setup, Appointments, Recall Types.

drtmz
by Tom Zaccaria
Mon Mar 25, 2019 2:53 am
Forum: Main Forum
Topic: Printing my Insurance Carriers list
Replies: 7
Views: 5026

Re: Printing my Insurance Carriers list

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
by Tom Zaccaria
Sun Mar 24, 2019 7:37 am
Forum: Main Forum
Topic: Printing my Insurance Carriers list
Replies: 7
Views: 5026

Re: Printing my Insurance Carriers list

There is:

Main Menu, Lists, Insurance Carriers

drtmz
by Tom Zaccaria
Sat Mar 23, 2019 12:13 pm
Forum: Main Forum
Topic: Printing my Insurance Carriers list
Replies: 7
Views: 5026

Re: Printing my Insurance Carriers list

Try this,
drtmz

select CarrierName, Address, Address2, City, State, Zip, Phone, ElectID
from carrier
by Tom Zaccaria
Thu Mar 21, 2019 6:54 am
Forum: Main Forum
Topic: Inactive Pt Report
Replies: 2
Views: 2292

Re: Inactive Pt Report

Try this, drtmz SELECT IFNULL(Left(c.CarrierName, 15), 'None') AS CarrierName, Left(GroupName, 15) AS GroupName, PlanType, p.PatNum, CONCAT(p.LName,', ',p.FName,' ',p.MiddleI) AS PatName, ib.SubscriberId,p.Patstatus FROM patient p LEFT JOIN patplan pp ON pp.PatNum=p.PatNum LEFT JOIN inssub ib ON ib....
by Tom Zaccaria
Wed Jan 09, 2019 9:56 am
Forum: Main Forum
Topic: Changing deceased account Guantor
Replies: 5
Views: 4369

Re: Changing deceased account Guantor

How about this for a start?

select patnum from patient
where patstatus = 5

It will at least give you a list of deceased patients. Then you could edit the individual records.

drtmz
by Tom Zaccaria
Tue Dec 04, 2018 5:59 pm
Forum: Main Forum
Topic: Welcome Back
Replies: 9
Views: 8498

Welcome Back

Did my eyes deceive me?
Welcome Back Arna !

drtmz
by Tom Zaccaria
Tue Dec 04, 2018 5:57 pm
Forum: Main Forum
Topic: Unearned income column
Replies: 4
Views: 3216

Re: Unearned income column

Thanks for the input.

drtmz
by Tom Zaccaria
Tue Dec 04, 2018 3:56 pm
Forum: Main Forum
Topic: Unearned income column
Replies: 4
Views: 3216

Re: Unearned income column

Looks like that box has to be unchecked every time a report is viewed.
Any way to make it the defalut?

drtmz
by Tom Zaccaria
Sun Dec 02, 2018 9:44 am
Forum: Main Forum
Topic: Unearned income column
Replies: 4
Views: 3216

Unearned income column

Just noticed there is an 'Unearned Income' column in the Monthly Production and Income reports. This forces the print out to be landscape.
We don't need this column. Any way to hide it?
Version18.3.20
Thanks,
drtmz
by Tom Zaccaria
Mon Nov 12, 2018 11:57 am
Forum: Main Forum
Topic: Statement Note
Replies: 2
Views: 2130

Re: Statement Note

Got it. Fairly well hidden.
drtmz
by Tom Zaccaria
Mon Nov 12, 2018 6:11 am
Forum: Main Forum
Topic: Statement Note
Replies: 2
Views: 2130

Statement Note

Looking for the Statement Note. According to the manual it is at Manage Module, Billing, Billing Options. Is it only for clinics?
Can't seem to find it. We are on version 18.3.22
Thanks,
drtmz
by Tom Zaccaria
Wed Oct 10, 2018 11:49 am
Forum: Main Forum
Topic: Create template database
Replies: 6
Views: 5153

Re: Create template database

I was searching for the right word, Split, but had one of those moments.
We are all here to help each other. This was my turn. (Plus I like seeing my name in print!!)

drtmz
by Tom Zaccaria
Wed Oct 10, 2018 2:45 am
Forum: Main Forum
Topic: Create template database
Replies: 6
Views: 5153

Re: Create template database

We have done it multiple times. We are on monthly support. Check with the conversions department. There is a cost involved but they were able to give us just what you want when we opened satellites.

drtmz
by Tom Zaccaria
Mon Sep 03, 2018 2:58 am
Forum: Main Forum
Topic: @ActivePatCount
Replies: 1
Views: 2418

Re: @ActivePatCount

This will give you the number of patients that visited at least one time over the last 18 months. For a longer or shorter time in the past change the '....interval 18 month;' to what ever you want. /*22 Count patients seen in last 18 months*/ Set @FromDate = curdate()-interval 18 month; set @ToDate ...
by Tom Zaccaria
Wed Aug 15, 2018 7:24 am
Forum: Main Forum
Topic: reports help
Replies: 3
Views: 3289

Re: reports help

Try this. It should get everyone, /*130 modified*/ SELECT patient.PatNum, patient.birthdate, DATE_FORMAT(MAX(ProcDate),'%m/%d/%Y') AS 'LastVisit', COUNT(procedurelog.ProcNum) AS '# Procs Total' FROM patient,procedurelog WHERE procedurelog.PatNum=patient.PatNum AND procedurelog.ProcStatus=2 AND patie...
by Tom Zaccaria
Wed Aug 01, 2018 11:38 am
Forum: Main Forum
Topic: reports help
Replies: 3
Views: 3289

Re: reports help

Does this help /*130*/ SELECT patient.PatNum, DATE_FORMAT(MAX(ProcDate),'%m/%d/%Y') AS 'LastVisit', COUNT(procedurelog.ProcNum) AS '# Procs Total' FROM patient,procedurelog WHERE procedurelog.PatNum=patient.PatNum AND procedurelog.ProcStatus=2 AND patient.PatStatus=0 GROUP BY procedurelog.PatNum HAV...
by Tom Zaccaria
Sun Jul 01, 2018 3:52 am
Forum: Main Forum
Topic: Appointment box info
Replies: 5
Views: 4320

Re: Appointment box info

This is the page you want. It controls the information in the appointment block.

http://www.opendental.com/manual/appoin ... indow.html

drtmz
by Tom Zaccaria
Sun Jul 01, 2018 2:36 am
Forum: Main Forum
Topic: Appointment box info
Replies: 5
Views: 4320

Re: Appointment box info

That information is controlled here:
Main Menu, Setup, Appointment Views, F1 or whatever view you are working on
Move the rows you want to display over to the right

drtmz
by Tom Zaccaria
Sat Jun 30, 2018 10:30 am
Forum: Main Forum
Topic: Appointment box info
Replies: 5
Views: 4320

Re: Appointment box info

Change your appointment View by pushing F-1, F-2 etc. See if that helps

drtmz
by Tom Zaccaria
Mon Jun 25, 2018 2:19 pm
Forum: Main Forum
Topic: Strange Unhandled Exception
Replies: 8
Views: 8906

Re: Strange Unhandled Exception

Although I did not stop mysql noone was logged in at the time of the backup.

drtmz
by Tom Zaccaria
Mon Jun 25, 2018 2:27 am
Forum: Main Forum
Topic: Strange Unhandled Exception
Replies: 8
Views: 8906

Re: Strange Unhandled Exception

I was able to run the database maintenance tool on the server, take a new backup and restore with no problem.

drtmz
OD 17.3.66
by Tom Zaccaria
Sat Jun 23, 2018 1:46 pm
Forum: Main Forum
Topic: Strange Unhandled Exception
Replies: 8
Views: 8906

Strange Unhandled Exception

When trying to restore a backup at home I am getting; Unhandled exception from ProgramEntry: Table '.\opendental\sigmessage' is marked as crashed and should be repaired MySql.Data.MySqlClient.MySqlException at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.Get...
by Tom Zaccaria
Wed Jun 06, 2018 11:48 am
Forum: Main Forum
Topic: Remove patients with zero payments from daily report
Replies: 2
Views: 2924

Re: Remove patients with zero payments from daily report

I will look into the employee issue. Thank you.

drtmz
by Tom Zaccaria
Wed Jun 06, 2018 3:09 am
Forum: Main Forum
Topic: Remove patients with zero payments from daily report
Replies: 2
Views: 2924

Remove patients with zero payments from daily report

We are having an issue with patients that are coming in for treatment, managed care, and pay nothing but still showing up on the daily payments report (Reports, Standard, Make the from and to the same date, Payments) with $0.00 payment. I thought I was able to switch this off previously but can't se...
by Tom Zaccaria
Wed May 16, 2018 2:22 pm
Forum: Main Forum
Topic: can't connect to mysql host after windows update
Replies: 19
Views: 29380

Re: can't connect to mysql host after windows update

I have had this problem from time to time after an update. Very frustrating. I usually just Right click on the Start Menu, Select File Explorer, Navigate to our server which is the 'F' drive. The server usually has a red 'X' over it which means the local machine is not connected to the server. I rig...
by Tom Zaccaria
Sat May 05, 2018 2:53 am
Forum: Main Forum
Topic: List of Emergency patients who never had cleaning done
Replies: 1
Views: 2834

Re: List of Emergency patients who never had cleaning done

Try this /*217 Patients who need followup-Patients with a procedure in a given list completed in date range but no other procedures on another date, apts are counted by procedures summed by date, so it works even if you so not use appointments*/ SET @FromDate='2016-1-01' , @ToDate='2016-12-31'; SELE...
by Tom Zaccaria
Wed Apr 18, 2018 11:18 am
Forum: Main Forum
Topic: Time card reports specifics
Replies: 9
Views: 10541

Re: Time card reports specifics

That did it. Perfect.
Very useful freebie!!

drtmz
by Tom Zaccaria
Wed Apr 18, 2018 3:06 am
Forum: Main Forum
Topic: Time card reports specifics
Replies: 9
Views: 10541

Re: Time card reports specifics

Yes. No data in the daterange column.
At least on my version 17.4.50

drtmz
by Tom Zaccaria
Tue Apr 17, 2018 12:49 pm
Forum: Main Forum
Topic: Time card reports specifics
Replies: 9
Views: 10541

Re: Time card reports specifics

It seems to work but the daterange field doesn't populate. It only returns employee and hours.

drtmz
by Tom Zaccaria
Wed Mar 21, 2018 2:57 pm
Forum: Main Forum
Topic: Procedure report
Replies: 1
Views: 2615

Re: Procedure report

You can start with this: Reports/Released user Queries Copy and paste below.. /*54*/ SET @FromDate='2007-01-01' , @ToDate='2007-01-15'; SELECT CONCAT(LName, ', ',FName, ' ', MiddleI) As Patient, pc.ProcCode, pl.ProcDate, pl.ProcFee, ps.SplitAmt FROM patient INNER JOIN procedurelog pl ON patient.PatN...
by Tom Zaccaria
Sun Mar 18, 2018 1:20 pm
Forum: Main Forum
Topic: Dr. Old and Dr. Young
Replies: 2
Views: 3981

Dr. Old and Dr. Young

Question posed to me last week. Dr. Old is selling his practice, patient charts, to Dr. Young. Both are Using OpenDental. The same version or very close to the same version I think. Is there any way to import the patients of Dr. Old on a patient by patient basis? I said,' No'. It would have to be a ...
by Tom Zaccaria
Mon Mar 12, 2018 5:04 pm
Forum: Main Forum
Topic: Login window out of focus. Bug?
Replies: 7
Views: 8662

Re: Login window out of focus. Bug?

Me too. On startup. I have to click the OD window to get focus and then it will let me enter my password and start. Otherwise nothing.
Thought it was fixed but so far not so lucky.

drtmz
Version 17.3.66
by Tom Zaccaria
Thu Mar 01, 2018 3:43 am
Forum: Main Forum
Topic: Add Insurance Plan to Query #164
Replies: 4
Views: 4109

Re: Add Insurance Plan to Query #164

OK Thanks
drtmz
by Tom Zaccaria
Wed Feb 28, 2018 12:41 pm
Forum: Main Forum
Topic: Add Insurance Plan to Query #164
Replies: 4
Views: 4109

Re: Add Insurance Plan to Query #164

Perfecto. OD support to the rescue again.
Great Work.
drtmz
by Tom Zaccaria
Wed Feb 28, 2018 4:41 am
Forum: Main Forum
Topic: Add Insurance Plan to Query #164
Replies: 4
Views: 4109

Add Insurance Plan to Query #164

I am trying to add the patient's current insurance plan to query #164 (below). Any help would be appreciated. Thanks drtmz /*164 Returns all treatment planned procedures for active patients without a scheduled OR planned apt, who were last seen in a given date range with phone numbers, useful for th...
by Tom Zaccaria
Tue Jan 16, 2018 4:55 am
Forum: Main Forum
Topic: Wrong patient's name on Pan
Replies: 1
Views: 2296

Wrong patient's name on Pan

Yesterday we took a panarex x-ray while in the wrong patient panel. The pan was supposed to be for Mrs. Jones (not her real name) but the panel selected was for Mrs. Smith (also not her real name). We are able to export the panarex and import it to the correct patient's file. The only thing now is t...
by Tom Zaccaria
Sun Dec 31, 2017 3:45 am
Forum: Main Forum
Topic: Gray shade in graphical tooth chart
Replies: 9
Views: 13487

Re: Gray shade in graphical tooth chart

This has been an ongoing issue which was supposed to be fixes a couple of versions ago. We still get it randomly. Sometimes if you select another module and then go back to the chart it is fixes.

drtmz
by Tom Zaccaria
Mon Dec 25, 2017 3:50 am
Forum: Main Forum
Topic: Prescription report
Replies: 2
Views: 2698

Re: Prescription report

Try this

SET @FromDate='2017-01-01' , @ToDate='2017-12-31';
SELECT PatNum, RxDate, Drug, Disp, Refills, ProvNum
FROM rxpat
WHERE RxDate BETWEEN @FromDate AND @ToDate;

drtmz
by Tom Zaccaria
Wed Dec 13, 2017 3:52 am
Forum: Main Forum
Topic: Potential bug? Ver. 17.3.31
Replies: 2
Views: 3043

Re: Potential bug? Ver. 17.3.31

Yes the Mouse focus on startup is very annoying.

drtmz
by Tom Zaccaria
Fri Oct 27, 2017 2:39 am
Forum: Main Forum
Topic: maximum connections
Replies: 8
Views: 10277

Re: maximum connections

The .ini trick seemed to work for now.
Thanks
drtmz
by Tom Zaccaria
Wed Oct 25, 2017 4:16 am
Forum: Main Forum
Topic: maximum connections
Replies: 8
Views: 10277

maximum connections

Having an issue connecting to mysql that network guys can't seem to fix. Getting an error message 'unable to connect to mysql, maximum connections reached'. We are running windows server 2012, mysql 5.5, OD 17.2.13 with a combination of 20 desktops, laptops and notebooks, some wireless, some hard wi...
by Tom Zaccaria
Wed Sep 20, 2017 1:23 pm
Forum: Main Forum
Topic: Query 1238
Replies: 5
Views: 6499

Re: Query 1238

Try this one /*972 New patients with first appointment in date range*/ /*Query code written/modified: 05/05/2014*/ SET @FromDate='2014-04-01', @ToDate='2014-05-05'; SELECT DISTINCT CONCAT(p.FName, ' ', p.LName) AS 'Name', DATE_FORMAT(a.AptDateTime, '%m/%d/%Y %h:%i %p') AS 'Appointment', prd.Abbr AS ...
by Tom Zaccaria
Wed Sep 20, 2017 1:20 pm
Forum: Main Forum
Topic: Query 1238
Replies: 5
Views: 6499

Re: Query 1238

Yes. You would need a completely different query.

drtmz
by Tom Zaccaria
Wed Sep 20, 2017 10:35 am
Forum: Main Forum
Topic: Query for list of guarantors
Replies: 2
Views: 3532

Re: Query for list of guarantors

Been working with that one. It might be what I need.
Thanks for the input.

drtmz
by Tom Zaccaria
Tue Sep 19, 2017 3:20 pm
Forum: Main Forum
Topic: Query for list of guarantors
Replies: 2
Views: 3532

Query for list of guarantors

Need a list of guarantors for patients treated over a time span, say 2 years, and their insurance coverage (plan).
Checked query examples but nothing seems to quite fit my needs.
Any help or direction would be appreciated

Thanks
drtmz
by Tom Zaccaria
Mon Jul 10, 2017 11:26 am
Forum: Main Forum
Topic: Tooth chart on Treatment Plan
Replies: 7
Views: 8302

Re: Tooth chart on Treatment Plan

That did it. Thank you

drtmz
by Tom Zaccaria
Mon Jul 10, 2017 7:00 am
Forum: Main Forum
Topic: Tooth chart on Treatment Plan
Replies: 7
Views: 8302

Tooth chart on Treatment Plan

Just updated to 17.1 Now the graphic tooth chart prints on the Treatment Plan.
Where is the switch to turn this option off.

Thanks
drtmz
by Tom Zaccaria
Tue Apr 25, 2017 10:46 am
Forum: Main Forum
Topic: Total patient visits query
Replies: 1
Views: 3519

Total patient visits query

I am looking for a query to total the patient visits by time period, usually for one month, and by insurance carrier. Something like this with a total per carrier and per month; Patient visits CarrierName................................Jan...Feb...March../.....Total Aenta Medicare Hmo Premier..........
by Tom Zaccaria
Sun Apr 16, 2017 2:44 am
Forum: Main Forum
Topic: Update from 15.3 to 16.4
Replies: 4
Views: 7758

Re: Update from 15.3 to 16.4

I think the new version failed to copy on those workstations. On the machine affected go to File Explorer, Your server drive (in our case F), Opendentimages, SetupFiles, double click on Setup16.4, let it install and then do that for each workstation. There was an issue back then with the installer n...
by Tom Zaccaria
Wed Mar 15, 2017 2:55 am
Forum: Main Forum
Topic: Query for write-offs and or adjustments by insurance plan
Replies: 3
Views: 3212

Re: Query for write-offs and or adjustments by insurance pla

Cool. Not exactly what I needed but this should help.
Thank you

drtmz
by Tom Zaccaria
Tue Mar 14, 2017 10:22 am
Forum: Main Forum
Topic: Query for write-offs and or adjustments by insurance plan
Replies: 3
Views: 3212

Re: Query for write-offs and or adjustments by insurance pla

OK so I have this much so far: SELECT patnum, DateService, PlanNum, Claimfee, InspayAmt, dedapplied, writeoff FROM claim WHERE dateservice >'2017-1-1' AND dateservice < '2017-4-1' Group by plannum But I would like to add the ADA procedures to the line, or abbrdesc from the Proccode table. I stink at...
by Tom Zaccaria
Tue Mar 14, 2017 6:23 am
Forum: Main Forum
Topic: Query for write-offs and or adjustments by insurance plan
Replies: 3
Views: 3212

Query for write-offs and or adjustments by insurance plan

Been asked if we have a report/query similar to Softdent that shows the fee charged, amount paid and writeoff per insurance plan? Guessing it would be: Insurance....procedure..fee...amt paid by ins..amt paid by patient...writeoff Delta dental, prophy, fee charged, amount paid by ins, amount paid by ...
by Tom Zaccaria
Thu Feb 09, 2017 7:28 am
Forum: Main Forum
Topic: query for ppo/medicaid not seen in over 6 months
Replies: 4
Views: 8026

Re: query for ppo/medicaid not seen in over 6 months

Thanks for the superlative. This is a modification of query #1026 from OD's query examples page. Not my code. Try this: /*1026 Recall info for patients due in date range that don't have any future scheduled appointment. Only shows patients with any insurance carrier, showing date of last visit*/ /*C...
by Tom Zaccaria
Wed Feb 08, 2017 5:47 pm
Forum: Main Forum
Topic: query for ppo/medicaid not seen in over 6 months
Replies: 4
Views: 8026

Re: query for ppo/medicaid not seen in over 6 months

Looks like you want some kind of recall query. Does this help? Change the date range in line 5. /*1026 Recall info for patients due in date range that don't have any future scheduled appointment. Only shows patients with any insurance carrier, showing date of last visit*/ /*Change dates as needed in...
by Tom Zaccaria
Sat Feb 04, 2017 4:21 am
Forum: Main Forum
Topic: Today was my last day at Open Dental
Replies: 8
Views: 8253

Re: Today was my last day at Open Dental

Noooo! Say it isn't so!!
Rant over. Best of Luck. You were a valuable asset here on the forum.

drtmz
by Tom Zaccaria
Wed Feb 01, 2017 4:04 pm
Forum: Main Forum
Topic: AR, how to break down by time chunks ins/pt
Replies: 5
Views: 8430

Re: AR, how to break down by time chunks ins/pt

BTW Our founder, Jordan, turned me on to a way to control the AR many, many moons ago. Send bills out every day. Get get most of the payments upfront before the patient's go back for Tx. The balances from insurance payments or whatever are then billed every day. Insurances we follow up on after two ...
by Tom Zaccaria
Mon Jan 30, 2017 4:05 am
Forum: Main Forum
Topic: AR, how to break down by time chunks ins/pt
Replies: 5
Views: 8430

Re: AR, how to break down by time chunks ins/pt

You can put in today's date or try
SET @AsOf=CURDATE();

drtmz
by Tom Zaccaria
Sun Jan 29, 2017 2:44 pm
Forum: Main Forum
Topic: AR, how to break down by time chunks ins/pt
Replies: 5
Views: 8430

Re: AR, how to break down by time chunks ins/pt

Try this. (below) Most reports / queries are found here http://opendentalsoft.com:1942/ODQueryList/QueryList.aspx If you don't know how to do this, let us know. Change the date in line #2 /*781 Aging for families with any balance with patient and insurance estimates separated*/ SET @AsOf='2014-02-03...
by Tom Zaccaria
Mon Jan 09, 2017 3:31 pm
Forum: Main Forum
Topic: 2016 payment report for taxes
Replies: 4
Views: 5975

Re: 2016 payment report for taxes

Just stumbled upon this query from our query list. Surprised no one else pointed it out. /*1222 Income Tax Receipt */ /*Provides the guarentor who paid, when they paid, the amount, and the payment type. Each row is for a single family. Ordered by Guarentor name, date paid, and amount.*/ /*Query code...
by Tom Zaccaria
Sat Jan 07, 2017 4:11 am
Forum: Main Forum
Topic: 2016 payment report for taxes
Replies: 4
Views: 5975

Re: 2016 payment report for taxes

Since the report is by patient number you have to run it multiple times. Once for each person who made any payments.

drtmz
by Tom Zaccaria
Wed Jan 04, 2017 4:40 am
Forum: Main Forum
Topic: 2016 payment report for taxes
Replies: 4
Views: 5975

2016 payment report for taxes

The ball had just hit bottom in Times Square when we got our first call of 2017. It was a request for 'everything I paid you in 2016 for taxes'. For newbies to OD or those of you who may have forgotten. We use the following: /*75*/ SET @StartDate='2016-01-01'; SET @EndDate='2016-12-31'; SET @Patient...
by Tom Zaccaria
Tue Nov 29, 2016 2:33 pm
Forum: Main Forum
Topic: OpenDental Newsletter
Replies: 2
Views: 4308

OpenDental Newsletter

I am surprised that no body mentioned the spiffy OpenDental Newsletter that we received on Monday. Very useful information on the growth of the company. Equally surprised that no one mentioned the new building being planned and could it possibly be in the shape of a lower first molar. (Would have gu...
by Tom Zaccaria
Thu Nov 17, 2016 9:15 am
Forum: Main Forum
Topic: query help
Replies: 5
Views: 8159

Re: query help

No need. There are almost 1200 examples on the query page to fit most needs. Usually you can cobble something from the examples. If not, post to this group for added guidance.

drtmz
by Tom Zaccaria
Wed Nov 09, 2016 2:25 pm
Forum: Main Forum
Topic: query help
Replies: 5
Views: 8159

Re: query help

You may want to try query #1184

drtmz
by Tom Zaccaria
Mon Nov 07, 2016 5:59 am
Forum: Main Forum
Topic: New Patient report
Replies: 4
Views: 6920

Re: New Patient report

Can anybody help clear this up?
Which number is used for practice management purposes?

drtmz
by Tom Zaccaria
Fri Sep 30, 2016 2:53 am
Forum: Main Forum
Topic: appointment view
Replies: 4
Views: 6128

Re: appointment view

We use Appointment view F-2 which has all the information contained in Appointment view F-1 except it uses the patient's id number. Very ease to switch back and forth. Works great for us

drtmz
by Tom Zaccaria
Sun Sep 25, 2016 4:15 am
Forum: Main Forum
Topic: Query help add 'AbbrDesc' abbreviated description
Replies: 1
Views: 3305

Query help add 'AbbrDesc' abbreviated description

Looking for some help. Need to add field 'AbbrDesc' to the following query. Can't seem to get it to click. /*# 1022 Query code written/modified: 10/30/2014*/ SET @FromDate='2014-01-10', @ToDate='2014-01-10'; SELECT A.Provider,A.ProcCode, COUNT(A.ProcCode) AS 'Quantity', SUM(A.ProcFee) AS $ProcFee_, ...
by Tom Zaccaria
Wed Sep 21, 2016 3:06 pm
Forum: Main Forum
Topic: Need help to add email to a query
Replies: 2
Views: 3480

Re: Need help to add email to a query

try adding this line right after p.WirelessPhone,

p.email,

drtmz
by Tom Zaccaria
Fri Sep 02, 2016 12:54 pm
Forum: Main Forum
Topic: Trick to show missing crown/retained root tips on chart
Replies: 18
Views: 20572

Re: Trick to show missing crown/retained root tips on chart

What I am calling Condition is 'Entry Status' eg Treatment Planned, Existing Other, Existing Current...
Lists, Procedure Codes
Tooth is selected.

Maybe I have something else turned off or not selected!
I will try again tomorrow.

drtmz
by Tom Zaccaria
Fri Sep 02, 2016 11:07 am
Forum: Main Forum
Topic: Trick to show missing crown/retained root tips on chart
Replies: 18
Views: 20572

Re: Trick to show missing crown/retained root tips on chart

I tried to take a picture of my setting but can't figure out how to post it but here is what I have.

Paint Type = Crown Light (Tried Filling Light, no luck)
Treatment Area = Tooth
Color Override = Dark Blue
Category = Oral Surgery
Condition = Existing Other

drtmz
by Tom Zaccaria
Fri Sep 02, 2016 6:40 am
Forum: Main Forum
Topic: Trick to show missing crown/retained root tips on chart
Replies: 18
Views: 20572

Re: Trick to show missing crown/retained root tips on chart

Sorry guys/gals. I followed your directions and used green for color but nothing happened. Setup the code and the properties as you described, used a missing tooth area, Selected Existing Other from conditions but no luck. It is listed in the chart as a root tip but no graphic. We are on 16.2.30 drtmz
by Tom Zaccaria
Mon Aug 15, 2016 2:45 am
Forum: Main Forum
Topic: Updating OD - Stuck in File Copier loop
Replies: 3
Views: 6200

Re: Updating OD - Stuck in File Copier loop

We had a problem with this in the past.
On the Workstations, try going to OpenDentalImages folder, Setupfiles. Then double click on the latest version. This should install the new version on that workstation.
You sill have to do this with each workstation.

drtmz
by Tom Zaccaria
Thu Aug 11, 2016 2:52 am
Forum: Main Forum
Topic: OD settings for second office
Replies: 4
Views: 7991

Re: OD settings for second office

A split is the way to go. We did it and it works fine. Like with a conversion they do a trial split and let you see it and go from there.
There was a small fee but worth the trouble.

drtmz
by Tom Zaccaria
Sat Jul 23, 2016 3:03 am
Forum: Main Forum
Topic: Problems restoring OpenDental
Replies: 3
Views: 6180

Re: Problems restoring OpenDental

I have been on OD since it was OpenDentalSoft, one of the originals, and use Karen's Replicator for backup. Currently we are on 16.2.30. I have never had to stop MYSQL in the past to backup successfully. I do stop the service on my home computer before restoring. If I kick everybody off OD and run t...
by Tom Zaccaria
Fri Jul 22, 2016 8:30 am
Forum: Main Forum
Topic: Problems restoring OpenDental
Replies: 3
Views: 6180

Problems restoring OpenDental

For the past few months unless I Optimize OpenDental and then back it up to a jump drive I am getting this error when trying to restore at home.

MySql.Data.MySqlClient.MySqlException (0x80004005): Duplicate entry '1665470' for key 'PRIMARY'

Any ideas?
Thanks,
drtmz
by Tom Zaccaria
Fri Jun 17, 2016 7:28 am
Forum: Main Forum
Topic: Query for new patients and insurance plans
Replies: 1
Views: 3501

Query for new patients and insurance plans

Can someone direct me to a query that will return the count of new patients for each insurance plan over a time period? I would like to input the start and end date like we do with many of the present queries. Or yearly by month would be perfect! I am looking for: ................Jan....Feb...Mar......
by Tom Zaccaria
Fri Jun 17, 2016 7:21 am
Forum: Main Forum
Topic: Printing reports in landscape mode
Replies: 2
Views: 4463

Re: Printing reports in landscape mode

Not a big deal. I could take a column out or as I said export to excel.
Just thought there was an enhancement I missed along the way.

drtmz
by Tom Zaccaria
Fri Jun 17, 2016 6:06 am
Forum: Main Forum
Topic: Printing reports in landscape mode
Replies: 2
Views: 4463

Printing reports in landscape mode

Is it possible to print certain reports in landscape mode? Some of the reports have too many columns to fit portrait mode. Currently I have been exporting to excel and reformatting but that gets old.
Any other workaround I am missing?

Thanks,
drtmz
by Tom Zaccaria
Wed Jun 15, 2016 3:54 pm
Forum: Main Forum
Topic: Insurance Carrier list printed
Replies: 8
Views: 13987

Re: Insurance Carrier list printed

Try this: /*122*/ SELECT carrier.CarrierName, COUNT(DISTINCT p.PatNum) AS 'Patients' FROM carrier INNER JOIN insplan ip ON carrier.CarrierNum=ip.CarrierNum INNER JOIN inssub ib ON ib.PlanNum=ip.PlanNum INNER JOIN patplan pp ON pp.InsSubNum=ib.InsSubNum INNER JOIN patient p ON pp.PatNum=p.PatNum WHER...
by Tom Zaccaria
Fri Jun 03, 2016 2:58 am
Forum: Main Forum
Topic: Hygiene production
Replies: 2
Views: 4642

Re: Hygiene production

Would this work? /*126*/ SET @FromDate='2016-01-01' , @ToDate='2016-06-30'; SELECT Count(*),pv.Abbr, pc.ProcCode, pc.AbbrDesc, AVG(pl.ProcFee) as '$Ave. Fee' , SUM(pl.ProcFee) AS '$Tot. Prod' FROM patient INNER JOIN procedurelog pl ON patient.PatNum=pl.PatNum INNER JOIN procedurecode pc ON pl.CodeNu...
by Tom Zaccaria
Tue May 31, 2016 2:49 am
Forum: Main Forum
Topic: Surface Pro
Replies: 3
Views: 5199

Re: Surface Pro

They all work very well but we use laptops for X-rays.

drtmz
by Tom Zaccaria
Mon May 30, 2016 9:30 am
Forum: Main Forum
Topic: Surface Pro
Replies: 3
Views: 5199

Re: Surface Pro

We have three that we us use all the time on WIFI. Just set them up on a secure WIFI network.

drtmz
by Tom Zaccaria
Sun Apr 24, 2016 2:42 am
Forum: Main Forum
Topic: Adding a simple Dr Note (not a procedure note)
Replies: 4
Views: 5631

Re: Adding a simple Dr Note (not a procedure note)

CommLog is the best.
Built in already, nothing to add, kind of the industry standard for after hours communication or any communication, easily searchable later on.

drtmz
by Tom Zaccaria
Wed Mar 23, 2016 11:33 am
Forum: Main Forum
Topic: Patient Info Custom Fields
Replies: 4
Views: 5826

Re: Patient Info Custom Fields

Nice little query. Very useful.

drtmz
by Tom Zaccaria
Sun Mar 20, 2016 3:32 am
Forum: Main Forum
Topic: Export/Import Auto Notes
Replies: 4
Views: 6756

Re: Export/Import Auto Notes

You can copy the auto notes to Word. Save to a USB drive. Then copy and past them to the new office.
May take a few minutes but it is once and done, so to speak.

drtmz
by Tom Zaccaria
Fri Dec 18, 2015 5:33 pm
Forum: Main Forum
Topic: How about this report?
Replies: 9
Views: 10233

Re: How about this report?

Great. Thank you,
drtmz
by Tom Zaccaria
Wed Dec 16, 2015 4:17 am
Forum: Main Forum
Topic: How about this report?
Replies: 9
Views: 10233

Re: How about this report?

I wasn't looking for it but I like this query very much.
Would be even better if we could pull AbbrDesc from Procedurecode. This way you wouldn't have to remember what the ADA codes represent.
Nice find!

drtmz
by Tom Zaccaria
Wed Nov 18, 2015 2:47 pm
Forum: Developers
Topic: OD DataBase
Replies: 3
Views: 5469

Re: OD DataBase

Not a good idea. Access is not robust enough to handle all the tables in OD.

drtmz
by Tom Zaccaria
Wed Oct 28, 2015 1:41 pm
Forum: Main Forum
Topic: Search patient chart notes
Replies: 7
Views: 9385

Re: Search patient chart notes

That is exactly what I wanted.
Is this query detailed anywhere else? Can't believe I'm the only one who would find this useful. But maybe I'm the only forgetful-one.

OpenDental support comes thru again in record time.

Many thanks,
drtmz
by Tom Zaccaria
Wed Oct 28, 2015 9:31 am
Forum: Main Forum
Topic: Search patient chart notes
Replies: 7
Views: 9385

Re: Search patient chart notes

Guess I wasn't 100% clear. I was referring to the procedure notes. The notes that are written after a completed procedure. Better example for procedure D1110 Adult Prophy the notes might say, 'did prophy in the usual manner. Patient does not like Cavitron. Always requests topical. Might need deep cl...
by Tom Zaccaria
Wed Oct 28, 2015 9:14 am
Forum: Main Forum
Topic: Search patient chart notes
Replies: 7
Views: 9385

Re: Search patient chart notes

I will try both methods. Thanks
drtmz
by Tom Zaccaria
Wed Oct 28, 2015 4:46 am
Forum: Main Forum
Topic: Search patient chart notes
Replies: 7
Views: 9385

Search patient chart notes

Is there a way to search the patients' chart notes?
For example, I note during an exam that the patient moved to our area from California. But later forget the conversation but want to reference it for some reason.
Anyway to query for that information?

drtmz
by Tom Zaccaria
Wed Oct 21, 2015 2:55 am
Forum: Main Forum
Topic: Query for free time by provider
Replies: 1
Views: 3146

Query for free time by provider

Need a query that returns free time (time units) for a provider over length of time. For example, Doc A works three 8 hour days a week. That is 24 total hours. We us 15 minute intervals so that would be 96 time units total. I want to find the number of time units that were free as in cancelled or br...
by Tom Zaccaria
Thu Sep 17, 2015 12:06 pm
Forum: Main Forum
Topic: Patients with remaining 2015 insurance benefits
Replies: 1
Views: 2936

Patients with remaining 2015 insurance benefits

Looking for a query to return list of active patients with work to be done and unused 2015 insurance benefits.
I think we discussed and did this before but can't seem to find it.
Any help or direction will be appreciated.
drtmz
by Tom Zaccaria
Wed Jul 22, 2015 2:47 am
Forum: Main Forum
Topic: Bulk commlog note
Replies: 1
Views: 2536

Bulk commlog note

Is there a way to add a Commlog note to multiple patients on OpenDental. We are changing our broken appointment policy from 24 to 48 hours. I want to send out emails to say 1000 of our patients. Since I can only do this one at a time in OD and have it recorded I was looking to use Google or Yahoo fo...
by Tom Zaccaria
Tue Jun 09, 2015 3:35 am
Forum: Main Forum
Topic: Broken, Cancelled and Failed Appointments
Replies: 23
Views: 29012

Re: Broken, Cancelled and Failed Appointments

Didn't really need to make a procedure. Still was listed on a statement when we charged for a missed appointment as though it was a procedure. Still could track it with a query of the adjustment table. I guess some of these original features that are changed should be made optional as OD gets more a...
by Tom Zaccaria
Fri Jun 05, 2015 10:21 am
Forum: Main Forum
Topic: Glitch with employee hours totals
Replies: 2
Views: 2731

Re: Glitch with employee hours totals

That's what I thought would have to happen. We have to pretend they were in.
Will clock them in and out before the adjustment.

Thank you,
drtmz
by Tom Zaccaria
Fri Jun 05, 2015 2:58 am
Forum: Main Forum
Topic: Glitch with employee hours totals
Replies: 2
Views: 2731

Glitch with employee hours totals

Noticed recently that there is a glitch in query 538, below, 746 and 756. If the employee does not work any regular hours in the time period searched they are ignored in the queries. In two cases we had an employee not work but were given adjustment hours, one for maternity and one for a honeymoon, ...
by Tom Zaccaria
Thu May 28, 2015 2:20 pm
Forum: Main Forum
Topic: Broken, Cancelled and Failed Appointments
Replies: 23
Views: 29012

Re: Broken, Cancelled and Failed Appointments

We called support today. No way to change the Font on the missed appointment in the chart because it is now a procedure. But if you click on the appointment after it is broken and then click on 'Add Adjustment' in the bottom of the window you can differentiate between the type of adjustments. In our...
by Tom Zaccaria
Tue May 26, 2015 9:10 am
Forum: Main Forum
Topic: Broken, Cancelled and Failed Appointments
Replies: 23
Views: 29012

Re: Broken, Cancelled and Failed Appointments

Thought it changed the Font but seems it did not.
Went to:
Setup/Appointments/Appointment View/ProcColors
entered one for D9986 and changed the color back to Blue
Checked Show Previous Date
Saved everything

But no luck

Help! Staff is after me!
drtmz
by Tom Zaccaria
Mon May 25, 2015 12:41 pm
Forum: Main Forum
Topic: Broken, Cancelled and Failed Appointments
Replies: 23
Views: 29012

Re: Broken, Cancelled and Failed Appointments

OK That took care of the font issue. Never would have guessed it would be under Appointment View.
But any way to differentiate between the adjtypes?

I took a peek at the appointment table and everything there under aptstatus is recorded as 'Broken'.

Thanks
drtmz
by Tom Zaccaria
Fri May 22, 2015 8:40 am
Forum: Main Forum
Topic: Broken, Cancelled and Failed Appointments
Replies: 23
Views: 29012

Re: Broken, Cancelled and Failed Appointments

Also noticed that the D9986 is in black text.
We are used to the old blue. Much easier to pick up. Any way to change that font color?

drtmz
by Tom Zaccaria
Fri May 22, 2015 5:37 am
Forum: Main Forum
Topic: Broken, Cancelled and Failed Appointments
Replies: 23
Views: 29012

Broken, Cancelled and Failed Appointments

How are we differentiating

BA (break appointment day of),
CA (break appointment with 24 hours notice) and
FA ( didn't show up, no call)
appointments in version 15.2.3

They all seem to be lumped under Broken Appointments.

drtmz
by Tom Zaccaria
Sun May 03, 2015 3:01 am
Forum: Main Forum
Topic: XCopy backup problem
Replies: 13
Views: 14608

Re: XCopy backup problem

I restore from a thumb drive. In my case it is recognized as 'E drive'.
I stop the service, minimize that window,
restore,
maximize the stop window and start the service.
Click on OD, run as administrator and that's it

drtmz
by Tom Zaccaria
Sat May 02, 2015 10:42 am
Forum: Main Forum
Topic: XCopy backup problem
Replies: 13
Views: 14608

Re: XCopy backup problem

Are you in the right directory? Right click on the Start button in Windows 7 Pro 64 bit Search for Cmd.exe Right click to run as Administrator Type the following at the command prompt Net stop mysql (this will stop the service) Restore your files from backup and then type Net Start Mysql Exit Should...
by Tom Zaccaria
Fri Mar 20, 2015 5:12 am
Forum: Main Forum
Topic: Report for insures patient payments
Replies: 1
Views: 1729

Re: Report for insures patient payments

As luck would have it I just discovered query example #93 modified slightly was what I wanted.

drtmz
by Tom Zaccaria
Fri Mar 20, 2015 4:59 am
Forum: Main Forum
Topic: Report for insures patient payments
Replies: 1
Views: 1729

Report for insures patient payments

I had this report before but can't seem to put my fingers on it now. I need a report for 2014 or a time period consisting of what patients with a specific insurance plan actually paid our office by date or summary. Example: Patient...........Mr. Thisa Test Delta insurance..Delta Dental 2014-02-03......
by Tom Zaccaria
Thu Mar 05, 2015 12:01 pm
Forum: Main Forum
Topic: Custom statement
Replies: 2
Views: 2248

Re: Custom statement

Thank you

drtmz
by Tom Zaccaria
Tue Mar 03, 2015 1:56 pm
Forum: Main Forum
Topic: Custom statement
Replies: 2
Views: 2248

Custom statement

Designed a custom statement on a backup computer but can't find how to access it.
Does this statement take the place of the regular billing statements or is there a menu choice for it somewhere?

Thanks,
drtmz
by Tom Zaccaria
Fri Feb 27, 2015 9:49 am
Forum: Main Forum
Topic: Report - separate cash from credit card for patient income
Replies: 6
Views: 4878

Re: Report - separate cash from credit card for patient inco

This may help you from the examples page. Adjust the date within the quotes.

/*29*/ SELECT PayDate,PayType,PayAmt,CheckNum,BankBranch,PatNum
FROM payment
WHERE PayDate = '2015-02-23'
ORDER BY PayAmt

drtmz
by Tom Zaccaria
Wed Feb 04, 2015 4:34 am
Forum: Main Forum
Topic: Clinics selection in V 15.1.6
Replies: 2
Views: 2218

Clinics selection in V 15.1.6

Just downloaded OpenDental latest version 15.1.6. 1. Can I remove the 'Clinic' column from the daily payments report? This would make more room for the transactions to fit on one line and we don't use clinics. 2. I tried to look into this as an option and went to Main Menu, List as per the site but ...
by Tom Zaccaria
Thu Jan 29, 2015 9:09 am
Forum: Main Forum
Topic: Notes signing or not
Replies: 5
Views: 4552

Re: Notes signing or not

Typical typical dental folklore!
We don't sign anything. OpenDental inserts the treating doc's and assistant's initials and that's it.

drtmz
by Tom Zaccaria
Wed Jan 28, 2015 4:59 am
Forum: Main Forum
Topic: Morning Huddle Report
Replies: 15
Views: 20111

Re: Morning Huddle Report

This is getting interesting. Could we change the orientation to Landscape and add a column for date of last BW/FMX/PAN for the hygiene patients (those with a periodic exam, PerEx)? As in Column Heading of 'X-rays' BW 6-6-2014 FMX 6-6-2009 This would make it much easier to determine who is due for wh...
by Tom Zaccaria
Sat Jan 17, 2015 11:53 am
Forum: Main Forum
Topic: How to add patient.ChartNumber to Daily Payments Report
Replies: 4
Views: 3471

Re: How to add patient.ChartNumber to Daily Payments Report

In searching the database documentation I found that 'chart number' was used for previous programs'. I guess this means for docs that converted from another PMS.
OpenDental uses PatientNumber.

Does this help?

drtmz
by Tom Zaccaria
Thu Jan 08, 2015 8:00 am
Forum: Main Forum
Topic: Help me edit an existing Query Example
Replies: 2
Views: 2366

Re: Help me edit an existing Query Example

You can simply run the query, select print preview and record the total from the last page without modifying the query.

drtmz
by Tom Zaccaria
Fri Dec 12, 2014 10:27 am
Forum: Main Forum
Topic: Need to change this query a little bit....help please!
Replies: 8
Views: 5249

Re: Need to change this query a little bit....help please!

Lastly, this would give you only the patients with insurance coverage: /*505 Balances of patients with appointments on a given date*/ SELECT patient.LName,patient.FName,patient.EstBalance AS PatBal, patient.HasIns, g.BalTotal FROM appointment INNER JOIN patient ON appointment.PatNum=patient.PatNum I...
by Tom Zaccaria
Fri Dec 12, 2014 8:21 am
Forum: Main Forum
Topic: Need to change this query a little bit....help please!
Replies: 8
Views: 5249

Re: Need to change this query a little bit....help please!

This adds a column for insurance coverage; /*505 Balances of patients with appointments on a given date*/ SELECT patient.LName,patient.FName,patient.EstBalance AS PatBal, patient.HasIns, g.BalTotal FROM appointment INNER JOIN patient ON appointment.PatNum=patient.PatNum INNER JOIN patient g ON patie...
by Tom Zaccaria
Fri Dec 12, 2014 7:49 am
Forum: Main Forum
Topic: Need to change this query a little bit....help please!
Replies: 8
Views: 5249

Re: Need to change this query a little bit....help please!

This is one way of doing the date range /*505 Balances of patients with appointments on a given date*/ SELECT patient.LName,patient.FName,patient.EstBalance AS PatBal, g.BalTotal FROM appointment INNER JOIN patient ON appointment.PatNum=patient.PatNum INNER JOIN patient g ON patient.Guarantor=g.PatN...
by Tom Zaccaria
Fri Dec 12, 2014 7:38 am
Forum: Main Forum
Topic: Need to change this query a little bit....help please!
Replies: 8
Views: 5249

Re: Need to change this query a little bit....help please!

This should remove the appointment column /*505 Balances of patients with appointments on a given date*/ SET @AptDate='2010-08-03'; SELECT patient.LName,patient.FName,patient.EstBalance AS PatBal, g.BalTotal FROM appointment INNER JOIN patient ON appointment.PatNum=patient.PatNum INNER JOIN patient ...
by Tom Zaccaria
Thu Dec 11, 2014 1:06 pm
Forum: Advanced Topics
Topic: Active patients or patients seen in the last 24 months
Replies: 1
Views: 2659

Re: Active patients or patients seen in the last 24 months

Change the dates according to your needs # Count of active patients seen between two dates SET @pos=0; SELECT Year(ProcDate) AS Year, Month(ProcDate) AS month, COUNT(DISTINCT patient.PatNum)AS 'Patients' from patient, procedurelog WHERE procedurelog.patnum = patient.patnum AND patient.patstatus = '0...
by Tom Zaccaria
Wed Dec 03, 2014 11:11 am
Forum: Main Forum
Topic: Error with home restore
Replies: 4
Views: 3407

Re: Error with home restore

Throws Unhandled Exception box and the only thing I can do is Exit

I think we've come across this before but I cannot remember the cure!

drtmz
by Tom Zaccaria
Wed Dec 03, 2014 11:08 am
Forum: Main Forum
Topic: Error with home restore
Replies: 4
Views: 3407

Re: Error with home restore

OD won't start at all.
drtmz
by Tom Zaccaria
Wed Dec 03, 2014 4:21 am
Forum: Main Forum
Topic: Error with home restore
Replies: 4
Views: 3407

Error with home restore

Trying to restore my daily backup from yesterday and got this error,
'Duplicate entry '688306' for key 'PRIMARY''

I backup and restore the same way every day but do get this error from time to time. Wassup??
drtmz
by Tom Zaccaria
Sun Sep 21, 2014 2:55 am
Forum: Main Forum
Topic: Patient Purge
Replies: 1
Views: 1989

Re: Patient Purge

Yes you can do this. Call support and for a nominal fee they will do exactly what you are looking for.
We did it a while ago with a start-up and it worked great.
All you would have to do is change the pertinent information such as name, address, NIP# etc.
drtmz
by Tom Zaccaria
Thu Aug 21, 2014 7:12 pm
Forum: Main Forum
Topic: Trouble expanding schedule
Replies: 1
Views: 1713

Re: Trouble expanding schedule

Got the answer from our friends at OpenDental. The schedule will only show one year at a time. And I was reminded that I was the one that made this suggestion.
Ooops!!

drtmz
by Tom Zaccaria
Tue Aug 19, 2014 4:40 pm
Forum: Main Forum
Topic: Trouble expanding schedule
Replies: 1
Views: 1713

Trouble expanding schedule

Tried to expand our schedule today but it won't hold. Used Setup, Schedules Made changes which were basically to increase our schedule by one year, Exit schedule screen and then go back to check and the expanded portion of the schedule is gone. Anyone else have this issue? Did I miss something? We a...
by Tom Zaccaria
Wed Aug 13, 2014 3:58 am
Forum: Main Forum
Topic: Modified monthly totals in columns
Replies: 0
Views: 2395

Modified monthly totals in columns

Here is a modified query to find the monthly totals of the more popular procedures in columns. We add an 'AbbrDesc' description column and a yearly total on the right side. With help from our friends at OpenDental. Enjoy! drtmz ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ /*839 Count of procedures comple...
by Tom Zaccaria
Mon Aug 11, 2014 5:09 pm
Forum: Main Forum
Topic: Problem with a Case statement
Replies: 3
Views: 2792

Re: Problem with a Case statement

What I am trying to do is run the query on any day of this current week and get the hours totals for the previous two full weeks. For example if I run the query on Tuesday, August 12, 2014 I want the hours from July 28 to August 8. If I run the query on Wednesday, August 13, 2014 I want the same day...
by Tom Zaccaria
Fri Aug 08, 2014 4:13 am
Forum: Main Forum
Topic: Problem with a Case statement
Replies: 3
Views: 2792

Problem with a Case statement

I am trying to run a query of employee hours any day of the week and get the same results. The query works but the Case statement does not. Anyone have any ideas as to why this wont work? Thanks drtmz ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ /*Time Card Summary*/ CASE daterun WHEN DAYOFWEEK(C...
by Tom Zaccaria
Thu Jun 05, 2014 4:53 pm
Forum: Main Forum
Topic: Where is "Dentist Name or Practice Title" stored?
Replies: 3
Views: 2576

Re: Where is "Dentist Name or Practice Title" stored?

Did you try,
Setup, Miscellaneous, Text Title box?

drtmz
by Tom Zaccaria
Thu May 29, 2014 12:25 pm
Forum: Main Forum
Topic: Copy of OpenDental for new location
Replies: 2
Views: 2038

Re: Copy of OpenDental for new location

ok. Great. I will give them a call when ready.
drtmz