update valeu question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

INSERT INTO tblPhneNum(colPhoneNumbers) Values (8055551234);

Is this right? There are only two fields in the table the id field and the
phone nmbr which is an integer.

thanks,
 
INSERT INTO tblPhneNum(colPhoneNumbers) Values (8055551234);

Is this right? There are only two fields in the table the id field and the
phone nmbr which is an integer.

thanks,
Click to expand...

That's not a good idea. You'll never do arithmatic with a phone number! A Long
Integer is limited to 2 billion odd - and as a number, your example is over 8
billion. Make the phone number field Text type, and surround it with quotes in
the Values clause.

John W. Vinson [MVP]
 
Also this is not an update query. This is an insert query.

Update changes existing data in existing records. Insert adds a new record.

So, what do you want to do? Add a new record or change an existing record?

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top