Help with DDL QUERY

[calihiker]

I'm not too familiar with Data Definition Queries, but I thought it might be possible to make a query (In ACCESS)that deletes certain rows in a table. Any help would be very appreciated.

Here's what I am doing now, but I am getting a syntax message...

ALTER TABLE "2000 Gifts Drop1"
DROP COLUMN "Year Code";


Thanks,
Andre

 

[RickSpr]

This is very confusing. You said you want to delete certain rows, yet you're using a statement to drop a column.

If I assume you meant you want to delete a column, instead of "certain rows", then your post makes sense. Your syntax error is coming from the use of quotes around the table and column names. You need to use [square brackets] instead. The bracket syntax is used with names of things in the database; quotes are used to surround data values (in particular, SQL text literals).

Note that the preceding is a Jet convention. Other relational database management systems use different syntax.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein