how do i add extra columns (in table view) in Access?

[kricket]

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!

 

[Rick Brandt]

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.

 

[Vincent Johns]

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 <[email protected]>
Please feel free to quote anything I say here.