On Export I get: Too few parameters, expected 2?

[Guest]

On Export I get: Too few parameters, expected 2?

Hello,
I have a query that pulls up a file number along with the filing date. I
have parameters set to ask for the starting date and ending date, which will
pull all file numbers filed in between those dates.

I have set the parameters, in design view, under query>parameters, I have
[starting date] - date/time, [ending date] - date/time
In criteria for the date, I have ">=[starting date] And <=[ending date]"
The query runs perfectly.

My problem is that now I need to export this to a comma delimited text file,
but when I try I get this error "Too few parameters, expected 2"

Anyone know how to fix this? Thanks for any help anyone can give.

Here is my SQL stuff:
PARAMETERS [starting date] DateTime, [ending date] DateTime;
SELECT dbo_CaseTable.[File #], "this " &
OrdinalDate(DatePart("d",[IOEnteredDate])) & " day of " &
Format([IOEnteredDate],"mmmm") & ", " & Format([IOEnteredDate],"yyyy") & "."
AS LegalDate
FROM dbo_CaseTable
WHERE (((dbo_CaseTable.[File #])<>"11.*" And (dbo_CaseTable.[File #]) Not
Like "09.*") AND ((dbo_CaseTable.IOEnteredDate)>=[starting date] And
(dbo_CaseTable.IOEnteredDate)<=[ending date]))
ORDER BY dbo_CaseTable.IOEnteredDate;

 

[Guest]

Hi Adna,

Try this KB article:

(ACC2000 "Too Few parameters. Expected X" Error Message When
You Export Parameter Query as Text
http://support.microsoft.com/kb/269671

If that does not help, then try some of the other articles in this listing:

http://support.microsoft.com/search...20&ast=1&ast=2&ast=3&ast=4&ast=7&mode=a&adv=1


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________