Expression too complex to be evaluated

Coll

I'm receiving this message when running a query...

This expression is typed incorrectly or 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.

Here's the background. I have a query. I've figured out through
cutting and pasting which field is the culprit. So I have a field with
the following info...

eecat: Cat([allemp_12312007]![employment_category])

The function cat esstentially converts the values in the employment
category field to a numeric using a case statement.

Then I have this as my criteria for the field...

>[forms]![frmSwitchboard]![frame42]

Frame 42 is an option group with two options.

If I remove the criteria line, it seems to work fine. The baffling
part for me is that I have the exact same setup in another query (just
based on a different, but almost identical table) and it's working
fine. Any ideas?

Thanks.

Jun 27 '08 #1

Subscribe Post Reply

4982

Coll

On May 12, 2:43*pm, Coll <col_mcma...@hotmail.comwrote:

I'm receiving this message when running a query...

This expression is typed incorrectly or 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.

Here's the background. I have a query. I've figured out through
cutting and pasting which field is the culprit. So I have a field with
the following info...

eecat: Cat([allemp_12312007]![employment_category])

The function cat esstentially converts the values in the employment
category field to a numeric using a case statement.

Then I have this as my criteria for the field...

[forms]![frmSwitchboard]![frame42]

Frame 42 is an option group with two options.

If I remove the criteria line, it seems to work fine. The baffling
part for me is that I have the exact same setup in another query (just
based on a different, but almost identical table) and it's working
fine. Any ideas?

Thanks.

I think I may have figured it out, so no need to respond. Thanks.

Jun 27 '08 #2

by: Christos TZOTZIOY Georgiou | last post by:

Hi all, this post contains at the end a handy module that I've used quite often when I wanted to analyse the occasional complex expression and how it was to be evaluated. The function...

Python

he expression is typed incorrectly or it is too complex to be evaluated

by: | last post by:

I am trying to run the following agregate function in a parameterized query on Access2000: Min(.*sqr(./.)/) The query saved OK, but an attempt to run it results in the message: The expression...

ASP / Active Server Pages

format query expression from dialog as percent

by: Terencetrent | last post by:

I am trying to format a query expression drawn from a dialog box as percent. The original statement to get the value for the query is as follows: New%markup: !! The dialog box looks the...

Microsoft Access / VBA

Can Eval evaluate a date arithmetic expression?

by: Penguin | last post by:

For some odd reason, I am trying to do some complex time calculations that I want to let the user define. So I set up a table with EventID EventType EventExpression 1 ...

Microsoft Access / VBA

Is =GetMyCriteria() a valid criteria expression in query?

by: MLH | last post by:

Am repeating question with different subject heading, perhaps stating more clearly my problem... I have an A97 query (qryVehiclesNowners2) that has a table field in it named . Depending on the...

Microsoft Access / VBA

How to explain "evaluate the expression as a void expression"?

by: Jason luo | last post by:

Hi all, In c99-standard page 52,there is a sentence about void,as below: If an expression of any other type is evaluated as a void expression, its value or designator is discarded. I don't...

C / C++

"An expression can result in a value..."

by: Steven T. Hatton | last post by:

I'm trying to improve my formal understanding of C++. One significant part of that effort involves clarifying my understanding of the vocabulary used to describe the language. This is from the...

C / C++

Expression Too Complex Error

by: jessicaeatworld | last post by:

Hi, I'm using Access 2003 on Windows XP. My Error: This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated...

Microsoft Access / VBA

This Expression is to Complex

by: cmartin1986 | last post by:

I am trying to write a sql query to return a count of records from a user defined supplier in weekly buckets going back from a user defined date. I get an error saying "This expression is typed...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Expression too complex to be evaluated

Similar topics