Hi

I'm more familiar with MySQL but on this occasion need to run a query on Access as follows:

INSERT INTO [All Batches] (lName) VALUES ('Managing Partner') WHERE lName IS NULL;

When I run this I get a "Missing semicolon(;) at the end of SQL statement error" - but it's there! What am I doing wrong?

Also, am I using "IS NULL" correctly?

I dont think access will allow you to use Values with a Where clause.

To achieve your desired result you could use this -

INSERT INTO [All Batches] ( lname )
SELECT "Managing Partner" AS [Value]
FROM [All Batches]
WHERE ((([All Batches].lname) Is Null));

Jon

Are you trying to insert information or chang information within the table? It looks like you might be trying to update the IName where it is NULL. If so, you could use something like UPDATE [All Batches] SET IName = ("Managing Partner") WHERE IName IS NULL;

INSERT is used for appending records, so unless you are using the WHERE statement to filter where you are receiving the records from, there is no need for it.

Hope that makes sense, if not yell!!

Mike

Mike
EchoVue.com

Thanks both you guys. Yes, I was trying to do an update. Wasn't thinking straight!

No Problem, sometimes going from a world-class database server like MySQL to Access (which is a great program for what it does) can do a number on the brain cells!!

Mike
EchoVue.com