Re: Delete Query

From: Van T. Dinh (VanThien.Dinh_at_discussions.microsoft.com)
Date: 09/29/04 

Date: Thu, 30 Sep 2004 08:29:34 +1000

You need to use square brackets as you have special characters in names.
Try:

DELETE *
FROM Linkbase
WHERE (Linkbase.[NUMBER]) = ([LinkedDeletions18-1].[Number]);

I am not sure whether "Number" is a reserved word or not so I alse enclosed
it in square brackets. 

-- 
HTH
Van T. Dinh
MVP (Access)
"Tina" <anonymous@discussions.microsoft.com> wrote in message
news:3e4101c4a668$89431120$a501280a@phx.gbl...
> Based on your input this is what I have typed in SQL.
> However I keep getting asked for a parameter value. Thanks
> for your help
>
>
> DELETE *
> FROM Linkbase
> WHERE (Linkbase.NUMBER) = (LinkedDeletions18-1.Number);
>
>
>

Relevant Pages

  • Re: Date BETWEEN
    ... As Jerry mentioned, Date is a reserved word in Access, and should not be used ... so your query would look like: ... "Steve Wagner" wrote: ... square brackets around it like so: ...
    (microsoft.public.access.queries)
  • Re: Select a column name "Short Name"
    ... In Access SQL you use square brackets if the column name has a space, ... Time is a reserved word (current system time) ...
    (microsoft.public.access.queries)
  • Re: Access reserved word gotcha
    ... You can enclose database object names in square brackets to prevent this ... >> published clients page to my local server to test making it DSN-less, ... >> seems the word "container" is not a reserved word on their server ...
    (microsoft.public.frontpage.client)
  • Re: runtime error 2001
    ... You can get this error if one of the names is wrong, e.g. if the field is actually called [admin group] with a space. ... Try adding square brackets around the table name as well, ... Group is a reserved word in JET SQL, ... Perth, Western Australia ...
    (microsoft.public.access.queries)
  • sql in vb
    ... You are using special characters within your field and ... field and table names within square brackets. ... Name is a reserved word within Access due to ... its usage as a property for many objects - you should not ...
    (microsoft.public.access.modulesdaovba)