It is referring to a DNA test on two of more blood differences
I had to compare to a diagnostic question where I was comparing to a field looking for a blood disorder'
My string should have been Select ^ from NewPatients where BldImage = """ & TexsA & """ and PrevTest = """ & TestB & ""'.
I had '" & Tests & '" and this was my error.
Also part of the problem is that so many clients do not want to fo Microsoft upgrades. In fact the AHA said it was about 700 labs out of 9000 ththat refused to upgrade and old tables gave us a lot of problems, which did not tur out to be a table problem, but executing VDA code when up went from Access 2007 to Access 365.
Tom did a great job and thanks for all your help.
IchthyologistNeb