This expression is typed incorrectly,or it is too complex (Error 3

P

Pietro

Hi,

I'm using a query that gets its criteria from a form,it works very
well,if i choose language "English" or "Spanish",but i don't know what
happens if select "French".
I get an 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. (Error 3071)"

The query I'm using is
SELECT CapQNet.IntervalEn, CapQNet.[Service Request] AS SR,
CapQNet.Language, CapQNet.Dueto, CapQNet.Replied, CapQNet.Lockedby From
CapQNet WHERE (((CapQNet.IntervalEn)=[forms]![capmap]![interval]) AND
((CapQNet.Language)=[forms]![capmap]![Language]) AND ((CapQNet.Dueto) Between
[forms]![capmap]![data] And [forms]![capmap]![data2]) AND ((CapQNet.Replied)
Is Null))ORDER BY CapQNet.Replied;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subform not populating 5
Complicated elements in a table 9
Error 3071 9
Access 97, DATE() Function not working 3
Error at Break point 5
Expression error 7
expression is typed incorrectly..... 2
email report through module error but unknown where 2

Top