473,320 Members | 2,048 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

running query with the following error query1 is not a valid name. Make sure that it

3
I am running a query with the following Sql
Expand|Select|Wrap|Line Numbers
  1. SELECT [DRUG CHEMICAL PROPERTIES].CODE, [DRUG CHEMICAL PROPERTIES].[DRUG NAME], [DRUG CHEMICAL PROPERTIES].[NUMBER OF RINGS], [DRUG CHEMICAL PROPERTIES].[WATER SOLUBILITY]
  2. FROM [DRUG CHEMICAL PROPERTIES]
  3. WHERE ((([DRUG CHEMICAL PROPERTIES].[NUMBER OF RINGS])=[Please enter 2 or 3 or 4]) AND (([DRUG CHEMICAL PROPERTIES].[WATER SOLUBILITY])>[Please enter water Solubility larger than 0.0211 but not greater than 0.9778]));
and it is giving this error query1 is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. query 1 is the name of the query
Any ideas how can i solve this pls tkx
Kind Regards
thomas
Mar 23 '15 #1
5 2116
jimatqsi
1,271 Expert 1GB
There is no reference to "query1" in the SQL. So obviously the problem is not in this code unless [DRUG CHEMICAL PROPERTIES] is a query that makes reference to query1.

Tell us more. Is this a saved query or are you running this from VBA? If so, provide more of the surrounding code.

Jim
Mar 24 '15 #2
TAC1
3
drug chemical properties is a table where data on which query1 must run is stored
Mar 24 '15 #3
jimatqsi
1,271 Expert 1GB
And where is query1? You have shown us nothing with query1 mentioned except the error.
Mar 25 '15 #4
Rabbit
12,516 Expert Mod 8TB
Are you trying to save that query as query1? In which case, the code in the query has nothing to do with the error. I would check to see if you already have another object named query1. Or just save it with a different name.
Mar 25 '15 #5
TAC1
3
Thanks all for your help but the problem with the query was solved and it was that the criteria contained a decimal number while it must only include whole numbers
Apr 5 '15 #6

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

Similar topics

0
by: Jonas Gorauskas | last post by:
I am having this one problem on an app I am writing where it shows the following error on some error trapping that I did: Query failed: Error Number: 1064 Description: You have an error in...
0
by: tukaram.thatikonda | last post by:
Hi Guys, I have written a small windows application in VB.Net to test ADO.Net performance while executing long running query. The query works most of the time but fails sometime. I am trying...
1
by: Sean C. | last post by:
Helpful folks, I have recently migrated our test server, which runs Win NT 4, from V7.2 FP11 to V8.1.3. Just about everything works wondefully, except I am having major problems getting the...
1
by: timVerizon | last post by:
Hoping someone can help here.. Our application (C#.Net) was receiving IBM.Data.DB2.DB2Exceptions ERROR SQL0904N Unsuccessful execution caused by an unavailable resource. Reason code: '', type...
4
by: Kory | last post by:
How do you stop a long running query with a SQLConnection or SQLCommand? Calling Close on either just waits until the query is done. Is there a way to stop it? The following on a long query ...
0
by: SHPsalm139 | last post by:
We have a MS Access database which has VBA code to link to a .dbf file on a network drive using the following command: DoCmd.TransferDatabase acLink, "dBase IV", txtDBPath, acTable, ASTUTable &...
4
by: mrityunjay11 | last post by:
Error SQL query: CREATE TABLE per( item_name varchar, item_number int, payment_status int, payment_amount int, payment_currency int );
5
patjones
by: patjones | last post by:
Hi: I've got a backend database, with several tables linked together via one-to-many relationships, and a front end database that links to those tables. The problem is, when I attempt to look...
4
by: Nitish Muley | last post by:
Whenever I execute the following ASP code in IIS environment, I get the error as- "operation must be an updateable query" Following is a simple ASP code for insertion of record retrieved from...
3
by: dashtons7 | last post by:
I get the following message when I try to run the below program: builtins.NameError: global name 'gallons' is not defined def main(): square_feet = float(input("Enter the square feet of the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.