TAC1
Last Activity: Apr 5 '15, 08:16 PM
Joined: Mar 23 '15
Location:
-
TAC1 replied to running query with the following error query1 is not a valid name. Make sure that itin AccessThanks 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 -
TAC1 replied to running query with the following error query1 is not a valid name. Make sure that itin Accessdrug chemical properties is a table where data on which query1 must run is storedLeave a comment:
-
TAC1 started a topic running query with the following error query1 is not a valid name. Make sure that itin Accessrunning query with the following error query1 is not a valid name. Make sure that it
I am running a query with the following Sql
...Code:SELECT [DRUG CHEMICAL PROPERTIES].CODE, [DRUG CHEMICAL PROPERTIES].[DRUG NAME], [DRUG CHEMICAL PROPERTIES].[NUMBER OF RINGS], [DRUG CHEMICAL PROPERTIES].[WATER SOLUBILITY] FROM [DRUG CHEMICAL PROPERTIES] 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
Last edited by Rabbit; Mar 23 '15, 09:40 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
No activity results to display
Leave a comment: