Delete Field Code

[JUDO]

HELP me please.

I have a field named <> as part of an output from a crosstab query. The field needs to be there in order for the report to output correctly but once the data is written to a new table I would like to then delete that field in its entirety form the new table.

Can anybody help me please.

I am using Access 97.

 

[chergh]

This would be done via an SQL statement along the lines off:

ALTER TABLE
<Table Name>
DROP COLUMN <field name>

If the field is an index you need to add a DROP CONSTRAINT statement as well.