A
adna
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;
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;