NZ function compile error

[Arts]

I have a query like this: Name: Nz([S_Genus_Subgenus];[Genus])
and in SQLwindow: INSERT INTO Mytable ( ID, Name)
SELECT Diptera.ID, Nz([S_Genus_Subgenus], [Genus]) AS Name FROM Diptera;

The table Mytable exists. This worked a few months ago, but now I get a
compile error that says that Nz([S_Genus_Subgenus], [Genus]) AS Name is wrong.
What is wrong?

 

[Stefan Hoffmann]

hi Art,

The table Mytable exists. This worked a few months ago, but now I get a
compile error that says that Nz([S_Genus_Subgenus], [Genus]) AS Name is wrong.
What is wrong?

One line:

<http://groups.google.de/group/micro...rence+not+found&rnum=4&hl=de#c230c7349b569550>


mfG
--> stefan <--