This bug report occurs when a natural history recorder try's to export records in a useable format to us here at the record centre on his home computer. Thanks to anyone who can help!!

Exception occurred in application Recorder 6 at 28/01/2011 12:57:42.
Version : 6.10.4.120

Exception path:
EOleException : Incorrect syntax near the keyword 'and'

Last event\actions:
  TfrmIndOrg destroyed
  actReportWizard invoked
  TfrmFilterResult created
  TfrmFilterResult activated
  TdlgWizard created
  TfrmFilterResult deactivated
  TfrmFilterResult activated
  TdlgWizard destroyed
  TfrmFilterResult destroyed

Operating System : Windows XP  5.01.2600  Service Pack 3
Physical Memory available : 515,568 KB

DLLs loaded:
  advapi32.dll (5.1.2600.5755)
  comctl32.dll (5.82.2900.6028)
  comdlg32.dll (6.0.2900.5512)
  gdi32.dll (5.1.2600.5698)
  HHCtrl.ocx (5.2.3790.4110)
  kernel32.dll (5.1.2600.5781)
  mpr.dll (5.1.2600.5512)
  MS5.Dll (5.0.0.12)
  MS5User.Dll (5.0.0.4)
  odbc32.dll (3.525.3012.0)
  ole32.dll (5.1.2600.6010)
  oleaut32.dll (5.1.2600.5512)
  shell32.dll (6.0.2900.6018)
  user32.dll (5.1.2600.5512)
  version.dll (5.1.2600.5512)
  winmm.dll (5.1.2600.5512)
  winspool.drv (5.1.2600.5512)

Information has been saved to the file C:\Program Files\Recorder 6\LastError.txt