I am trying to create an export specification for a transfer text command in my application. I am trying to take a query and export to an text file. Here is the query:
SELECT A.Release_Number, C.Status_Number, C.Status_Description, C.Current_Function_Points AS Function_Count, C.Project_Type, [Metrics Total Estimated Hours].Total_Estimated_Hours, [Metrics Total Estimated Hours].Total_Completed_Hours
FROM Releases AS A, Metrics AS C INNER JOIN [Metrics Total Estimated Hours] ON C.Status_Number = [Metrics Total Estimated Hours].Status_Number
WHERE (((A.Production_Date) Between [Forms]![Workbook Search]![Start_Date] And [Forms]![Workbook Search]![End Date]) AND ((C.SLC_Phase)='Analyze') AND ((A.Release_Number)=[c].[Release_Number]));
I run the query with no errors but when I try to go to the Export Text Wizard section I get an error saying 'Too few parameters. Expected 2'. I usually get this kind of message on invalid queries but if the query ran fine on its own why won't it work when doing an export?
Any ideas on what I am doing wrong here.
SELECT A.Release_Number, C.Status_Number, C.Status_Description, C.Current_Function_Points AS Function_Count, C.Project_Type, [Metrics Total Estimated Hours].Total_Estimated_Hours, [Metrics Total Estimated Hours].Total_Completed_Hours
FROM Releases AS A, Metrics AS C INNER JOIN [Metrics Total Estimated Hours] ON C.Status_Number = [Metrics Total Estimated Hours].Status_Number
WHERE (((A.Production_Date) Between [Forms]![Workbook Search]![Start_Date] And [Forms]![Workbook Search]![End Date]) AND ((C.SLC_Phase)='Analyze') AND ((A.Release_Number)=[c].[Release_Number]));
I run the query with no errors but when I try to go to the Export Text Wizard section I get an error saying 'Too few parameters. Expected 2'. I usually get this kind of message on invalid queries but if the query ran fine on its own why won't it work when doing an export?
Any ideas on what I am doing wrong here.