Just got back form trip in north with two seasonal rangers. Different errors on each machines. One fixable- registry pointed to a different MSDE, odd but there ye go!

The other one is more tedious; Essentially I was unable to perfom reports on his machine using the wizard. Most errors occurred during final phase and by the example below, make the barest sense to me.

For example, when plugging in the first key 'CI000011000000D5' into 'Find key addin' then trying every permutation, I get results for Survey Event, Biotope occurence, and Location. Only the location would have had anything to do with the parameters within the selected report. 

I understand that making sense of error logs is just the start, but to say that it's embarrassing trying to tshow someone to use R6 with confidence & then getting errors for everything I do, is a little rich..

Exception occurred in application Recorder 6 at 28/08/2006 16-30-54.
Version : 6.7.2.77

Exception path:
EOleException : The column prefix 'ITS' does not match with a table name or alias name used in the query
TExceptionPath : 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(Integer, Null)  as [Event_Vague_Date_Start], Convert(Integer, Null)  as [Event_Vague_Date_End], Convert(varchar(2), Null) Collate SQL_Latin1_general_CP1_CI_AS as [Event_Vague_Date_Type], Convert(varchar(100), Null) Collate SQL_Latin1_general_CP1_CI_AS as [Event Location], Convert(varchar(100), Null) Collate SQL_Latin1_general_CP1_CI_AS as [Taxon Status Long Name] into "#REPORT_OUTPUT" From (((((Taxon_Occurrence LEFT JOIN Sample ON Taxon_Occurrence.sample_Key = Sample.Sample_Key ) LEFT JOIN Taxon_Determination ON Taxon_Determination.Taxon_Occurrence_Key = Taxon_Occurrence.Taxon_Occurrence_Key ) LEFT JOIN Location LSamp ON Sample.Location_Key = LSamp.Location_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 Location_Name LNSamp ON LSamp.Location_Key = LNSamp.Location_Key ) LEFT JOIN Taxon_List_Item ON Taxon_List_Item.Taxon_List_Item_Key = ITN.Taxon_List_Item_Key WHERE (LNSamp.Preferred = 1 or LNSamp.Preferred is null) AND LSamp.Location_Key IN ('CI000011000000D5','CI000011000000E2','CI0001930000002P','CI0001930000004N','CI0001930000004O','CI0001930000004P','CI0001930000004Q','CI0001930000004R','CI0001930000004S','CI0001930000004T','CI0001930000004U') AND ITS.Taxon_List_Item_Key IN ('NHMSYS0000530069')

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

Operating System : Windows 2000  5.00.2195  Service Pack 4
Physical Memory available : 130,544 KB

DLLs loaded:
  advapi32.dll (5.0.2195.6710)
  comctl32.dll (5.81.4916.400)
  comdlg32.dll (5.0.3700.6693)
  gdi32.dll (5.0.2195.6762)
  HHCtrl.ocx (5.2.3735.1)
  kernel32.dll (5.0.2195.6794)
  mpr.dll (5.0.2195.6611)
  MS5.Dll (5.0.0.12)
  MS5User.Dll (5.0.0.4)
  odbc32.dll (3.520.9030.0)
  ole32.dll (5.0.2195.6810)
  oleaut32.dll (2.40.4522.0)
  shell32.dll (5.0.3700.6705)
  user32.dll (5.0.2195.6799)
  version.dll (5.0.2195.6623)
  winmm.dll (5.0.2161.1)
  winspool.drv (5.0.2195.6659)

I look forward to a little guidance, Cheers now, Rob.