Microsoft Access parameter query question?

Question

Any time I try to include a field (from a table that uses a combo box under Lookup in its design view) in a query, for example lets say I have a field where I can choose a community from a drop down list, and I want to have the criteria in a query [Enter a community], I always get the error "This expression is typed incorrectly, 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."
How is this fixable? Any feedback would be helpful!

Answer 1

Well, if you've defined Lookup properties in design view of a table, that should have no effect on the query. The Lookup property only affects the datasheet view as you are entering data into that field. I'd say there is something wrong with your query criteria (and you say your query is getting the field directly from the table, not a form or another query). Post back the exact criteria you are using in that field, or e-mail me directly, and I'll try to assist.

Answer 2

It sounds as if you are trying to enter the actual text of the field into the query. Use an auto-increment id for the droplist result as the key in the new query, then do a lookup of the text to display the result.

Answer 3

in case you have been writing a hotel centred visitor e book as an example and additionally you wanted to discover visitors staying between 2 dates you may bypass to question wizard, basic question, and then choose the fields you prefer to incorporate, as a effect, arrival date, and departure date. Then in the standards field, you may style #>12/06/09# in the advent standards, and #<19/06/09# in the departure standards. i desire that's what you have been searching for