Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CREATE A CUSTOM FIELDS IN A TABLE

Status
Not open for further replies.

villica

Programmer
Feb 25, 2000
332
CA
Hello everyone,

I hope I can get some help this time. I have posted two similar questions and all I getting is refer to something in the help file. Well I have and I am still stuck. I am starting to feel pretty stupid.

A couple of access courses is not enough for what I want to accomplish

I am trying to use the Alter statment
I want to create field on an existing table in this format
fieldname followed by somenumber

EVENT & SOMENUMBER

output of fieldname
KLONDIKE1 WILL BE OUTPUT.
is this possible

any suggestions please

villica
 
You can do it in 2 steps:

docmd.RunSQL("alter table table1 add column myfield text(10)")
docmd.RunSQL("update table1 set myfield ='KLONDIKE1 '")


Mike Pastore

Hats off to (Roy) Harper
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top