If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do i add extra columns (in table view) in Access?
I do not mean colums as they appear in the design view (e.g., formatted) but
rather in the excel looking sheet. I need to have some questions that require extra columns so as to designate there are extra parts to this question. Not sure if that makes sense... Thanks! |
#2
|
|||
|
|||
how do i add extra columns (in table view) in Access?
kricket wrote:
I do not mean colums as they appear in the design view (e.g., formatted) but rather in the excel looking sheet. I need to have some questions that require extra columns so as to designate there are extra parts to this question. Not sure if that makes sense... No, it doesn't. The columns you see in the datsheet are those that are defined in design view. You can have "calculated" or "derived" columns in queries that use expressions and/or data from other columns, but in a table the only columns you see are those that are defined in the design view of the table. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#3
|
|||
|
|||
how do i add extra columns (in table view) in Access?
I think that Table Design View is the easiest way to add them. (There
are others, but I don't think any of them are any less difficult.) Just give each field a name, select the data type, and save the Table. Do you maybe mean that you want different numbers of fields (columns) to be shown for different records (rows)? To do that, Access provides features such as subforms or subqueries. Ask for assistance here if you need it. -- Vincent Johns Please feel free to quote anything I say here. kricket wrote: I do not mean colums as they appear in the design view (e.g., formatted) but rather in the excel looking sheet. I need to have some questions that require extra columns so as to designate there are extra parts to this question. Not sure if that makes sense... Thanks! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Add New Field to DB | Karen | Database Design | 7 | October 19th, 2005 08:03 PM |
Toolbars, Drop-Down Menus | Rick | New Users | 1 | September 21st, 2005 11:17 AM |
Access combo box-show name, not ID, in table? | write on | New Users | 30 | April 30th, 2005 09:11 PM |
Why is a French Spellchecker a "required" update for English speak | French Spellcheck Required? | General Discussion | 23 | April 26th, 2005 01:17 AM |
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |