473,779 Members | 2,089 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

This Expression is to Complex

37 New Member
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 incorrectly or it is too complex to be evaluated...." When I orginally wrote this it would simply start from Date() and go back weekly and still had a user defined supplier. What i did was add a combo box to my "front" form for a user input date, at which point I started getting the error.

Here is a section of my code.
Expand|Select|Wrap|Line Numbers
  1. SELECT "8 Weeks Ago" as Week, Count([tbl-tag_master].[Received Date]) AS [CountOfReceived Date], Count([tbl-tag_master].[resub recived date]) AS [Count of Resub]
  2. FROM [tbl-tag_master]
  3. WHERE (((([tbl-tag_master].[Received Date]) Between ([forms]![front]![combo8]-56) And ([forms]![front]![combo8]-49))) and (([tbl-tag_master].[supplier]) like ([forms]![front]![combo12])));
  4.  
Any help would be great!!


Thanks,
Chad
Jan 9 '08 #1
4 1687
cmartin1986
37 New Member
bump........... ...........
Jan 9 '08 #2
cmartin1986
37 New Member
anyone????????? ????????
Jan 17 '08 #3
jaxjagfan
254 Recognized Expert Contributor
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 incorrectly or it is too complex to be evaluated...." When I orginally wrote this it would simply start from Date() and go back weekly and still had a user defined supplier. What i did was add a combo box to my "front" form for a user input date, at which point I started getting the error.

Here is a section of my code.
Expand|Select|Wrap|Line Numbers
  1. SELECT "8 Weeks Ago" as Week, Count([tbl-tag_master].[Received Date]) AS [CountOfReceived Date], Count([tbl-tag_master].[resub recived date]) AS [Count of Resub]
  2. FROM [tbl-tag_master]
  3. WHERE (((([tbl-tag_master].[Received Date]) Between ([forms]![front]![combo8]-56) And ([forms]![front]![combo8]-49))) and (([tbl-tag_master].[supplier]) like ([forms]![front]![combo12])));
  4.  
Any help would be great!!


Thanks,
Chad
Go back and take a look at your criteria. Make a copy of the query and try it with just the "supplier" criteria and then with just the "received date" criteria. This will help you find where the problem is. When I view the queries in SQL View I remove most of the bracketing so its easier to troubleshoot.

Are you returning these values in the form, a subform or report? Did you think about using a DCount for this?
Jan 17 '08 #4
cmartin1986
37 New Member
I am using it in a form. I have tried to narrow it down all my criteria seems to work seperatly but when i put them all together i get the too complex thing. Is it really too complex? That seems hard to believe. Again i am thankful for any help.
Jan 18 '08 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

39
7889
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 is typed incorrectly or it is too complex to be evaluated If the sintax correct? Perhaps it is, otherwise it would not save. What can be done about it?
5
2247
by: Bob Stearns | last post by:
Is there an easy way (without duplication of the complex expression) to use the same complex expression in all three places? Will something like this work? WITH (SELECT t.*, <complex expr> AS x FROM <base_table> AS t) AS wt SELECT * FROM wt WHERE ABS(x)<10 ORDER BY ABS(x)
1
7983
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 values up from a table called NewMarkup. It appears in the dialog box with a percent format. However, when I try to call that value in my query it shows it as a decimal.
8
1454
by: - | last post by:
Hi to All, To reproduce: The expression: object result = flag ? (long) 0 : (double) 0; always evaluated as a double... see dissassembly to ensure the bad compiled code.
3
2305
by: Joe | last post by:
Hi, I have been using a regular expression that I don’t uite understand to filter the valid email address. My regular expression is as follows: <asp:RegularExpressionValidator id="valValidEmail" runat="server" ControlToValidate="txtEmail" ValidationExpression="^(+)(\.+)*@(+)(\.+)*(\.{2,4})$"
13
7060
by: Vij | last post by:
is there a cross platform (msvc, gcc and solaris CC) simple regex library available? All we need is a simple lib that will do string matching, nothing too complex.
6
2026
by: Jon Paal | last post by:
what is vb equiv. of ++ shown in C# ?
6
1912
by: jonny | last post by:
I am new to web design and programming and was wonder which of these two would be better to invest my time to learn. Visual Web Developer 2005 vs. Microsoft Expression. I would like to make very complex and neat looking web sites. I plan I doing a lot of reports and charts pulling data out of database. Please let me know which way I should go. Also, what is the best code
14
1264
by: Nick Maclaren | last post by:
For reasons that I won't explain, as they are too complicated and not terribly relevant, I am interested in discovering what people actually use regular expressions for. Not the subject domain, but the construction of the regular expressions. I know about computer scientists and parsing, and I know about the use of relatively simple ones for things like extracting HTML links from Web pages. But I don't have much feel for the (probably...
1
1618
by: Anderson | last post by:
Hi! I´m using a OleDbDataAdapter to fill my DataSet object, and to do the database update work the OleDbCommandBuilder class. But, when I call the OleDbDataAdapter.Update(DataSet) method VB returns me a "Expression too complex" exception. Any help?
0
9636
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9474
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10306
Oralloy
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10075
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9931
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8961
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6727
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
4037
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2869
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.