> 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
bla
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,
pl
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,
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 co
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 Da
Hi,
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."
I really don't want to have to download, modify and upload the DB because
it's over 8MB - having not really used the MODIFY statement before, can
anyone advise what my qu
6 matches
Mail list logo