I have just tried to produce a report listing all birds which are on WCA/Birds Directive/Red & Amber lists - this worked fine until I included the columns to show the designation for each record at which point Recorder consistently falls over with the following error message, any ideas?

Craig
-----------------
date/time         : 2009-12-21, 09:57:34, 734ms
computer name     : WS10
user name         : slawsoc
operating system  : Windows XP Service Pack 3 build 2600
system language   : English
system up time    : 1 hour 55 minutes
program up time   : 1 hour 47 minutes
processors        : 2x Intel(R) Pentium(R) 4 CPU 3.00GHz
physical memory   : 406/1023 MB (free/total)
free disk space   : (C:) 6.09 GB (R:) 15.60 GB
display mode      : 1600x1200, 32 bit
process id        : $8c8
allocated memory  : 40.73 MB
command line      : RecorderApp.exe /262350
executable        : RecorderApp.exe
exec. date/time   : 2009-08-05 12:49
version           : 6.14.4.212
madExcept version : 2.7k
exception class   : TExceptionPath
exception message : An error occurred executing the following SQL: SELECT Distinct Taxon_Occurrence.Taxon_Occurrence_Key AS Occurrence_Key, 'T' AS Type, Convert(char(16), null) collate SQL_Latin1_General_CP1_CI_AS as SURVEY_KEY, Convert(char(16), null) collate SQL_Latin1_General_CP1_CI_AS as SURVEY_EVENT_KEY, Convert(char(16), null) collate SQL_Latin1_General_CP1_CI_AS as SAMPLE_KEY, Convert(char(16), null) collate SQL_Latin1_General_CP1_CI_AS as LIST_ITEM_KEY , Convert(char(1),Null) as [Obs Key], Convert(bit, Null)  as [Obs Confidential], Convert(char(1),Null) as [Sample Type], Convert(char(1),Null) as [Det Type], Convert(varchar(8000), Null) Collate SQL_Latin1_general_CP1_CI_AS as [Obs Abundances (LC)], Convert(varchar(100), Null) Collate SQL_Latin1_general_CP1_CI_AS as [Survey Name], Convert(varchar(40), Null) Collate SQL_Latin1_general_CP1_CI_AS as [Sample_Spatial_Ref], Convert(varchar(4), Null) Collate SQL_Latin1_general_CP1_CI_AS as [Sample_Spatial_Ref_System], Convert(float, Null)  as [Sample_Lat], Convert(float, Null)  as [Sample_Long], Convert(varchar(20), Null) Collate SQL_Latin1_general_CP1_CI_AS as [Sample 1 km Square], Convert(Integer, Null)  as [Sample_Vague_Date_Start], Convert(Integer, Null)  as [Sample_Vague_Date_End], Convert(varchar(2), Null) Collate SQL_Latin1_general_CP1_CI_AS as [Sample_Vague_Date_Type], Convert(varchar(100), Null) Collate SQL_Latin1_general_CP1_CI_AS as [Sample Location], Convert(varchar(100), Null) Collate SQL_Latin1_general_CP1_CI_AS as [Sample Location Name], Convert(varchar(8000), Null) Collate SQL_Latin1_general_CP1_CI_AS as [Sample Recorders], Convert(varchar(75), Null) Collate SQL_Latin1_general_CP1_CI_AS as [Taxon Common Name], Convert(varchar(75), Null) Collate SQL_Latin1_general_CP1_CI_AS as [Recommended Taxon Name], Convert(varchar(50), Null) Collate SQL_Latin1_general_CP1_CI_AS as [Taxon Group], Convert(char(1),Null) as [Wildlife & Countryside Act Sch 1 Part 1], Convert(char(1),Null) as [Wildlife & Countryside Act Sch 1 Part 2], Convert(char(1),Null) as [Birds Directive Annex 1], Convert(char(1),Null) as [Bird:Red], Convert(char(1),Null) as [Bird:Amber], Convert(char(1),Null) as [Preferred TVK] into "#REPORT_OUTPUT" From ((((((Taxon_Occurrence LEFT JOIN Taxon_Determination ON Taxon_Determination.Taxon_Occurrence_Key = Taxon_Occurrence.Taxon_Occurrence_Key and Taxon_Determination.Preferred = 1 ) LEFT JOIN Sample ON Taxon_Occurrence.sample_Key = Sample.Sample_Key ) LEFT JOIN Index_Taxon_Name ITN ON (ITN.Taxon_List_Item_Key = Taxon_Determination.Taxon_List_Item_Key and ITN.System_Supplied_Data=1) ) LEFT JOIN Survey_Event ON Survey_Event.Survey_Event_Key = Sample.Survey_Event_Key ) LEFT JOIN Taxon_List_Item ON Taxon_List_Item.Taxon_List_Item_Key = ITN.Taxon_List_Item_Key ) LEFT JOIN Survey ON Survey.Survey_Key = Survey_Event.Survey_Key ) LEFT JOIN Index_Taxon_Designation ON Taxon_List_Item.Taxon_List_Item_Key = Index_Taxon_Designation.Taxon_List_Item_Key WHERE Survey.Survey_Key NOT IN (SELECT Survey_Key FROM User_Survey_Restriction USR WHERE USR.Name_Key = 'SR000011000002QA') AND Index_Taxon_Designation.Taxon_Designation_Type_Key IN ('NHMSYS0020443051','NHMSYS0020443052','NBNSYS0000000051','NBNSYS0000000001','NBNSYS0000000002').

main thread ($8d8):
008978d0 RecorderApp.exe 
7e4196c2 user32.dll       DispatchMessageA

thread $9a4:
7c90e514 ntdll.dll     KiFastSystemCallRet
7c90df48 ntdll.dll     NtWaitForMultipleObjects
7c80958a kernel32.dll  WaitForMultipleObjectsEx
7e4195f3 user32.dll    MsgWaitForMultipleObjectsEx
7e4196a3 user32.dll    MsgWaitForMultipleObjects
>> created by main thread ($8d8) at:
4ec67b7f gdiplus.dll   

thread $a80:
7c90e514 ntdll.dll  KiFastSystemCallRet
7c90df48 ntdll.dll  NtWaitForMultipleObjects

thread $ae4:
7c90e514 ntdll.dll     KiFastSystemCallRet
7c90df58 ntdll.dll     NtWaitForSingleObject
7c8025d5 kernel32.dll  WaitForSingleObjectEx
7c80253d kernel32.dll  WaitForSingleObject

thread $cec:
7c90e514 ntdll.dll  KiFastSystemCallRet
7c90d218 ntdll.dll  NtDelayExecution

thread $784:
7c90e514 ntdll.dll   KiFastSystemCallRet
7c90daa8 ntdll.dll   NtReplyWaitReceivePortEx
>> created by thread $ca8 at:
77e7df36 RPCRT4.dll 

modules:
00340000 C4DLL.DLL         1.0.0.1          R:
003b0000 MS5User.Dll       5.0.0.4          R:
00400000 RecorderApp.exe   6.14.4.212       R:
01360000 ms5cnv.dll        5.0.0.10         R:
01af0000 odbcint.dll       3.525.1132.0     C:\WINDOWS\system32
02950000 xpsp2res.dll      5.1.2600.5512    C:\WINDOWS\system32
02cd0000 msader15.dll      2.81.1132.0      C:\Program Files\Common Files\System\ado
03d20000 SQLOLEDB.RLL      2000.85.1132.0   C:\Program Files\Common Files\System\Ole DB
03d30000 msadcer.dll       2.81.1132.0      C:\Program Files\Common Files\System\msadc
04060000 GoToKey.ocx       6.0.1.10         R:\Addins
042a0000 NBNExchange.ocx   6.13.2.24        R:\Addins
044f0000 Phenology.ocx     6.0.1.10         R:\Addins
04810000 ShowUnchecked.ocx 6.0.0.13         R:\Addins
04a40000 StdValLib.dll     6.14.3.208       R:\Addins
04c40000 SurveyDelete.ocx  6.0.0.29         R:\Addins
05020000 Normaliz.dll      6.0.5441.0       C:\WINDOWS\system32
0f9a0000 VBAJET32.DLL      6.0.1.9432       C:\WINDOWS\system32
0f9c0000 expsrv.dll        6.0.72.9590      C:\WINDOWS\system32
10000000 MS5.Dll           5.0.0.12         R:
1b000000 msjet40.dll       4.0.9511.0       C:\WINDOWS\system32
1b2c0000 msjter40.dll      4.0.9502.0       C:\WINDOWS\system32
1b2d0000 MSJINT40.DLL      4.0.9502.0       C:\WINDOWS\system32
1b570000 msjetoledb40.dll  4.0.9502.0       C:\WINDOWS\system32
1b5d0000 mswstr10.dll      4.0.9502.0       C:\WINDOWS\system32
1b800000 msjtes40.dll      4.0.9502.0       C:\WINDOWS\system32
20000000 xpsp3res.dll      5.1.2600.5512    C:\WINDOWS\system32
3d930000 WININET.dll       8.0.6001.18854   C:\WINDOWS\system32
3dfd0000 iertutil.dll      8.0.6001.18854   C:\WINDOWS\system32
4ca30000 msadrh15.dll      2.81.1132.0      C:\Program Files\Common Files\System\ado
4d650000 msadox.dll        2.81.1132.0      C:\Program Files\Common Files\System\ado
4dd00000 sqloledb.dll      2000.85.1132.0   C:\Program Files\Common Files\System\Ole DB
4de10000 msado15.dll       2.81.1132.0      C:\Program Files\Common Files\System\ado
4ec50000 gdiplus.dll       5.2.6001.22319   C:\WINDOWS\WinSxS\x86_Microsoft.Windows.GdiPlus_6595b64144ccf1df_1.0.6001.22319_x-ww_f0b4c2df
57100000 sfShellTools.dll  1.0.2.6          C:\Program Files\SmartFTP Client
5ad70000 uxtheme.dll       6.0.2900.5512    C:\WINDOWS\system32
5b860000 NETAPI32.dll      5.1.2600.5694    C:\WINDOWS\system32
5d090000 comctl32.dll      5.82.2900.5512   C:\WINDOWS\system32
5edd0000 olepro32.dll      5.1.2600.5512    C:\WINDOWS\system32
5fe80000 odbccp32.dll      3.525.1132.0     C:\WINDOWS\system32
605d0000 mslbui.dll        5.1.2600.5512    C:\WINDOWS\system32
60e30000 MSDATL3.dll       2.81.1132.0      C:\Program Files\Common Files\System\Ole DB
662b0000 hnetcfg.dll       5.1.2600.5512    C:\WINDOWS\system32
68000000 rsaenh.dll        5.1.2600.5507    C:\WINDOWS\system32
68100000 dssenh.dll        5.1.2600.5507    C:\WINDOWS\system32
69b10000 msxml4.dll        4.20.9876.0      C:\WINDOWS\system32
6d4f0000 DBNETLIB.DLL      2000.85.1132.0   C:\WINDOWS\system32
71a50000 mswsock.dll       5.1.2600.5625    C:\WINDOWS\system32
71a90000 wshtcpip.dll      5.1.2600.5512    C:\WINDOWS\System32
71aa0000 WS2HELP.dll       5.1.2600.5512    C:\WINDOWS\system32
71ab0000 WS2_32.dll        5.1.2600.5512    C:\WINDOWS\system32
71ad0000 wsock32.dll       5.1.2600.5512    C:\WINDOWS\system32
71b20000 mpr.dll           5.1.2600.5512    C:\WINDOWS\system32
71bf0000 SAMLIB.dll        5.1.2600.5512    C:\WINDOWS\System32
71c10000 ntlanman.dll      5.1.2600.5512    C:\WINDOWS\System32
71c80000 NETRAP.dll        5.1.2600.5512    C:\WINDOWS\System32
71c90000 NETUI1.dll        5.1.2600.5512    C:\WINDOWS\System32
71cd0000 NETUI0.dll        5.1.2600.5512    C:\WINDOWS\System32
71f80000 security.dll      5.1.2600.5512    C:\WINDOWS\system32
73000000 winspool.drv      5.1.2600.5512    C:\WINDOWS\system32
73160000 oledb32.dll       2.81.1132.0      C:\Program Files\Common Files\System\Ole DB
732e0000 RICHED32.DLL      5.1.2600.0       C:\WINDOWS\system32
74060000 msadce.dll        2.81.3002.0      C:\Program Files\Common Files\System\msadc
74320000 odbc32.dll        3.525.1132.0     C:\WINDOWS\system32
74720000 MSCTF.dll         5.1.2600.5512    C:\WINDOWS\system32
74e30000 RICHED20.dll      5.30.23.1230     C:\WINDOWS\system32
750b0000 RESUTILS.DLL      5.1.2600.5512    C:\WINDOWS\system32
750f0000 MTXCLU.DLL        2001.12.4414.706 C:\WINDOWS\system32
75130000 colbact.DLL       2001.12.4414.700 C:\WINDOWS\system32
75350000 OLEDB32R.DLL      2.81.1132.0      C:\Program Files\Common Files\System\Ole DB
754d0000 CRYPTUI.dll       5.131.2600.5512  C:\WINDOWS\system32
755c0000 msctfime.ime      5.1.2600.5512    C:\WINDOWS\system32
75f60000 drprov.dll        5.1.2600.5512    C:\WINDOWS\System32
75f70000 davclnt.dll       5.1.2600.5512    C:\WINDOWS\System32
75f80000 browseui.dll      6.0.2900.5512    C:\WINDOWS\system32
76390000 IMM32.DLL         5.1.2600.5512    C:\WINDOWS\system32
763b0000 comdlg32.dll      6.0.2900.5512    C:\WINDOWS\system32
765b0000 MSDART.DLL        2.81.1132.0      C:\WINDOWS\system32
76600000 CSCDLL.dll        5.1.2600.5512    C:\WINDOWS\System32
76620000 comsvcs.dll       2001.12.4414.702 C:\WINDOWS\system32
76780000 SHFolder.dll      6.0.2900.5512    C:\WINDOWS\system32
76790000 cryptdll.dll      5.1.2600.5512    C:\WINDOWS\system32
767a0000 ntdsapi.dll       5.1.2600.5512    C:\WINDOWS\system32
767f0000 schannel.dll      5.1.2600.5834    C:\WINDOWS\system32
76990000 ntshrui.dll       5.1.2600.5512    C:\WINDOWS\system32
769c0000 USERENV.dll       5.1.2600.5512    C:\WINDOWS\system32
76b20000 ATL.DLL           3.5.2284.2       C:\WINDOWS\system32
76b40000 winmm.dll         5.1.2600.5512    C:\WINDOWS\system32
76c30000 WINTRUST.dll      5.131.2600.5512  C:\WINDOWS\system32
76c90000 IMAGEHLP.dll      5.1.2600.5512    C:\WINDOWS\system32
76d10000 CLUSAPI.DLL       5.1.2600.5512    C:\WINDOWS\system32
76d60000 iphlpapi.dll      5.1.2600.5512    C:\WINDOWS\system32
76f20000 DNSAPI.dll        5.1.2600.5625    C:\WINDOWS\system32
76f60000 WLDAP32.dll       5.1.2600.5512    C:\WINDOWS\system32
76fb0000 winrnr.dll        5.1.2600.5512    C:\WINDOWS\System32
76fc0000 rasadhlp.dll      5.1.2600.5512    C:\WINDOWS\system32
76fd0000 CLBCATQ.DLL       2001.12.4414.700 C:\WINDOWS\system32
77050000 COMRes.dll        2001.12.4414.700 C:\WINDOWS\system32
77120000 oleaut32.dll      5.1.2600.5512    C:\WINDOWS\system32
773d0000 comctl32.dll      6.0.2900.5512    C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.5512_x-ww_35d4ce83
774e0000 ole32.dll         5.1.2600.5512    C:\WINDOWS\system32
77920000 SETUPAPI.dll      5.1.2600.5512    C:\WINDOWS\system32
77a20000 cscui.dll         5.1.2600.5512    C:\WINDOWS\System32
77a80000 crypt32.dll       5.131.2600.5512  C:\WINDOWS\system32
77b20000 MSASN1.dll        5.1.2600.5875    C:\WINDOWS\system32
77b40000 appHelp.dll       5.1.2600.5512    C:\WINDOWS\system32
77c00000 version.dll       5.1.2600.5512    C:\WINDOWS\system32
77c10000 msvcrt.dll        7.0.2600.5512    C:\WINDOWS\system32
77c70000 msv1_0.dll        5.1.2600.5876    C:\WINDOWS\system32
77dd0000 advapi32.dll      5.1.2600.5755    C:\WINDOWS\system32
77e70000 RPCRT4.dll        5.1.2600.5795    C:\WINDOWS\system32
77f10000 GDI32.dll         5.1.2600.5698    C:\WINDOWS\system32
77f60000 SHLWAPI.dll       6.0.2900.5512    C:\WINDOWS\system32
77fe0000 Secur32.dll       5.1.2600.5834    C:\WINDOWS\system32
78130000 urlmon.dll        8.0.6001.18854   C:\WINDOWS\system32
7c800000 kernel32.dll      5.1.2600.5781    C:\WINDOWS\system32
7c900000 ntdll.dll         5.1.2600.5755    C:\WINDOWS\system32
7c9c0000 shell32.dll       6.0.2900.5622    C:\WINDOWS\system32
7e290000 shdocvw.dll       6.0.2900.5512    C:\WINDOWS\system32
7e410000 user32.dll        5.1.2600.5512    C:\WINDOWS\system32
7e4b0000 HHCtrl.ocx        5.2.3790.4110    C:\WINDOWS\system32
7e720000 SXS.DLL           5.1.2600.5512    C:\WINDOWS\system32

Exception Stack

----------------
EOleException : Parameter object is improperly defined. Inconsistent or incomplete information was provided