|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 7th, 2007, 09:09 AM
posted to microsoft.public.access.queries
|
|||
|
|||
Nz function compilation error
My query looks like this:
SELECT Diptera.ID, NZ([Species],[Subgenus]) AS Name INTO [synonym] FROM Diptera; I get a compile error. What sould I do? DAO 3.6 Object Library is ok. The query worked 2 days ago -- Thank you. 
|
|
#2
June 7th, 2007, 10:37 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Nz function compilation error
Works for me, what exactly is the error message?
James On 7 Jun, 09:09, Arts wrote: My query looks like this: SELECT Diptera.ID, NZ([Species],[Subgenus]) AS Name INTO [synonym] FROM Diptera; I get a compile error. What sould I do? DAO 3.6 Object Library is ok. The query worked 2 days ago -- Thank you.
|
|
#3
June 7th, 2007, 11:11 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Nz function compilation error
Any broken/missing reference will cause this, not just DAO.
"Arts" wrote in message ... My query looks like this: SELECT Diptera.ID, NZ([Species],[Subgenus]) AS Name INTO [synonym] FROM Diptera; I get a compile error. What sould I do? DAO 3.6 Object Library is ok. The query worked 2 days ago -- Thank you.
|
|
#4
June 8th, 2007, 08:37 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Nz function compilation error
The message is: Compile error in query clause Nz([Species], [Subgenus])
(freely translated to English) -- Thank you. James skrev: Works for me, what exactly is the error message? James On 7 Jun, 09:09, Arts wrote: My query looks like this: SELECT Diptera.ID, NZ([Species],[Subgenus]) AS Name INTO [synonym] FROM Diptera; I get a compile error. What sould I do? DAO 3.6 Object Library is ok. The query worked 2 days ago -- Thank you.
|
|
#5
June 8th, 2007, 09:20 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Nz function compilation error
Hi,
I would start by removing reserved words in access...like "Name" rename this to something else. SELECT Diptera.ID, NZ([Species],[Subgenus]) AS Name INTO [synonym] Arts wrote: My query looks like this: SELECT Diptera.ID, NZ([Species],[Subgenus]) AS Name INTO [synonym] FROM Diptera; I get a compile error. What sould I do? DAO 3.6 Object Library is ok. The query worked 2 days ago -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200706/1
|
|
#6
June 8th, 2007, 09:31 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Nz function compilation error
Sorry, the query does not include "Name", this is only a translation into
English. The word I am using is "Art" -- Thank you. AccessVandal via AccessMonster.com skrev: Hi, I would start by removing reserved words in access...like "Name" rename this to something else. SELECT Diptera.ID, NZ([Species],[Subgenus]) AS Name INTO [synonym] Arts wrote: My query looks like this: SELECT Diptera.ID, NZ([Species],[Subgenus]) AS Name INTO [synonym] FROM Diptera; I get a compile error. What sould I do? DAO 3.6 Object Library is ok. The query worked 2 days ago -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200706/1
|
|
#7
June 8th, 2007, 04:45 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Nz function compilation error
Are you still using it from within Access? or from somewhere else?
Have you tried to replace Nz(a, b) by iif( a is null, b, a) ? Vanderghast, Access MVP "Arts" wrote in message ... My query looks like this: SELECT Diptera.ID, NZ([Species],[Subgenus]) AS Name INTO [synonym] FROM Diptera; I get a compile error. What sould I do? DAO 3.6 Object Library is ok. The query worked 2 days ago -- Thank you.
|
|
#8
June 11th, 2007, 08:56 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Nz function compilation error
I am using it from within Access.
I have tried iif( a is null, b, a) and that works ok. -- Thank you. Michel Walsh skrev: Are you still using it from within Access? or from somewhere else? Have you tried to replace Nz(a, b) by iif( a is null, b, a) ? Vanderghast, Access MVP "Arts" wrote in message ... My query looks like this: SELECT Diptera.ID, NZ([Species],[Subgenus]) AS Name INTO [synonym] FROM Diptera; I get a compile error. What sould I do? DAO 3.6 Object Library is ok. The query worked 2 days ago -- Thank you.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
