Search results

I would like to rename fields with a query. I did do a search and came up with this: "ALTER TABLE "your_table" RENAME COLUMN "old_field" to "new_field" But where do i type this? or is this SQL? How do i do it in access? Tnx allot. Bob: sorry for all the questions....tnx for your help.

Howdi. What i have is a is a table with 2 fields. field 1 contains numbers field 2 empty. Then i have a query that extract certain data from field 1 and put it in field 2 and it displays correctly in the query but now i want to take that data in field 2 in the query and copy it to the table. I...

Howdi. Im new with access but can help my self. What i want to do is copy parts of a field into a new field. For example: Now: field1 000011110000 want it to be: field1 field2 000011110000 1111 Tnx allot.

what i want to do is: I have a "create user form" if i click add i want the program to automatically create a new table with certain fields for each new user added? Tnx