Parameter query error

[TracyBell]

I'm trying to create what seems like a simple parameter query and I keep getting an error stating,

"The expression is typed incorrect, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables."

(Attached is a screen shot after clicking on "help" with this error.) I have checked and double checked that I am entering the parameter per instructions in Access and can't figure out what's going on.

When I remove the parameter and just put "Yes" in the criteria the query works fine. Also works fine with no criteria.



Please help! Thanks in advance.

[ssanfu]

Without seeing the SQL of the query, it is hard to make any suggestions.

Would you post the SQL of the query?

[TracyBell]

Thanks for the response. OK, I realize my database isn't normalized and I'm working on a new version to fix that - but I'm not sure that should affect this anyway. Here's the SQL:

SELECT tblOwner.OwnerID, tblOwner.OCompanyName, tblOwner.OFirstName1, tblOwner.OLastName1, tblOwner.OFirstName2, tblOwner.OLastName2, tblOwner.OAddress, tblOwner.OCity, tblOwner.OState, tblOwner.OZip, tblOwner.OOfficePhone, tblOwner.OHomePhone, tblOwner.OMobilePhone, tblOwner.OEmail, tblOwner.Bank_FiduciaryName, tblOwner.Bank_FiduciaryAccount, tblOwner.Current, tblOwner.PMAgreementStart, tblOwner.PMAgreementEnd, tblOwner.OTaxID_SSN, tblOwner.ContingencyReserve, tblOwner.[LeasingFee%], tblOwner.[ManagementFee%], tblOwner.[M&RExpenseThreshold], tblOwner.SDAccountMaint, tblOwner.DebtSvc_Taxes_Insurance, tblOwner.EquityCheck, tblOwner.EquityBank_FiduciaryName, tblOwner.EquityBank_FiduciaryAccount, tblOwner.MoSummary_Statement, tblOwner.EndDate, tblOwner.MoSummary_SendTo
FROM tblOwner
WHERE (((tblOwner.Current)=[Enter YES for current:]));

[ssanfu]

I think you are getting the error because you have a reserved word ("Current") as a field name. And it is not very descriptive... maybe use "AcctIsCurrent".

Try adding brackets around the field name in the WHERE clause of the SQL:

WHERE (((tblOwner.[Current])=[Enter YES for current:]));

Here is a link to a list of reserved words in Access and SQL:

http://allenbrowne.com/AppIssueBadWord.html


Also, you shouldn't use special characters in object names (ex !@#$%^&*() ) . Only use letters, numbers and the underscore ( _ ).

[TracyBell]

Thanks for the info.
I changed the field name to "CurrentAcct" (also updated other fields which had symbols) and then changed the WHERE clause to:

WHERE (((tblOwner.[CurrentAcct])=[Enter YES for current:]));

but I'm still getting the same error. Any other ideas?

[ssanfu]

I created a table with your fieldnames and then created the query. I didn't have any data, but when the query executed, I didn't have any errors either.

The only thing I can suggest is to delete the query, do a Compile and repair, close the database, open it and recreate the query.