Will
I need to modify a table on one of my Databases - to add 2 Yes/No fields.
The DB is Access, and the table name Pending.
alter table pending add column col1 yesno, col2 yesno;
Nick
**
Information in this email is
Nick,
I need to modify a table on one of my Databases - to add 2 Yes/No
fields.
The DB is Access, and the table name Pending.
alter table pending add column col1 yesno, col2 yesno;
Strange problem with that - probably Access being pathetic. It creates the
column perfectly happily, and
Will,
Sorry, what do you mean by it isn't - just says the format is blank?
Nick
**
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
Sorry, what do you mean by it isn't - just says the format is blank?
Sorry, didn't explain it properly. In the Design View in Access, the new
field's data type is Yes/No. But then looking at the properties, the
*format* should be Yes/No (other options are On/Off or True False), but it's
Sorry - I meant ALTER not modify...
Thanks in advance.
Will
- Original Message -
From: W Luke [EMAIL PROTECTED]
Newsgroups: cf-talk
Sent: Sunday, September 23, 2001 11:48 PM
Subject: MODIFY sql command
Hi,
I need to modify a table on one of my Databases - to add 2 Yes/No fields.
5 matches
Mail list logo