With Export File Wizard, "Two Few Parameters. Expected 2."

[HoganGroup]

I need to create an export file for the following brutal query to upload into a state database (go figure it's a government report!) All was good in my world until I tried to export. Manually or TransferText, didn't matter, it just hated me. The above error stopped me cold in my tracks. Searching about, no one else seems to know what the heck this stupid error is. Anybody? Bueller?

Code: ( sql )

1.
SELECT DISTINCT Format([Forms]![frmReports]![txtFrom],"mm/yyyy") AS [Month], tblSettings.CDEVendorNo AS Vendor, tblFamilies.FamilyID AS FICN, tblFamilies.SSN, tblFamilies.ParentALast, tblFamilies.ParentAFirst, "" AS MI, tblFamilies.ParentAZip, "N" AS CW, "N" AS 75SMI, tblEligibility.Need, tblFamilies.FIPS, Format([qryFirstStart_Family].[FirstStart],"mm/dd/yyyy") AS FamilyStart, tblKids.KidLast, tblKids.KidFirst, "" AS MI2, Format([DOB],"mm/dd/yyyy") AS DB, IIf([tblKids.ExceptionalNeeds]=Yes,"Y","N") AS IEP, Format([qryFirstStartLastEnd_Kid].[FirstStart],"mm/dd/yyyy") AS KidStart, tblSettings.TaxIDNo AS EIN, IIf([ProviderType]="FCCN","02","04") AS Type, "CCTR" AS Program1, "" AS Program2, "" AS Program3, Format([qryFirstStart_Family].[FirstStart],"mm/dd/yyyy") AS FamilyStart2
2.
FROM tblSettings, tblProviders INNER JOIN (((((tblKids INNER JOIN tblFamilies ON tblKids.FamilyID = tblFamilies.FamilyID) INNER JOIN tblEligibility ON tblFamilies.FamilyID = tblEligibility.FamilyID) INNER JOIN (tblSchedules INNER JOIN qryToFrom ON tblSchedules.SchID = qryToFrom.SchID) ON tblKids.KidID = tblSchedules.KidID) INNER JOIN qryFirstStart_Family ON tblFamilies.FamilyID = qryFirstStart_Family.FamilyID) INNER JOIN qryFirstStartLastEnd_Kid ON tblKids.KidID = qryFirstStartLastEnd_Kid.KidID) ON tblProviders.ProviderID = tblSchedules.ProviderID;

 

[Remou]

You refer to several queries, but you have not included SQL for them. The error above can occur, for example, when you refer improperly to a form in SQL that is running in VBA. It usually means that Access cannot find a value for data included in a Where statement.

The square brackets here are incorrect:
IIf([tblKids.ExceptionalNeeds]=Yes,"Y","N")

best to drop them.

 

[dhookom]

I would try replace

   SELECT DISTINCT Format([Forms]![frmReports]![txtFrom],"mm/yyyy") AS [Month],

with

   SELECT DISTINCT "11/2007" AS [Month],

See if the errors goes from 2 to 1.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]