Adding a field

[Guest]

Ok I have imported all my files from excel to msdb now I need to add a field
for notes in the table's, queries, etc. that I have created. how do I do
that? oh and I tried doing add a field and it adds it at the begining of the
table and i need it at the end of the table.

 

[Douglas J. Steele]

Where the field appears is irrelevant. You shouldn't be working directly
with tables: you should be using forms to work with your data, and you can
put the field anywhere you like on the form. If you've added the field to
your table and don't see it in the list of available fields for your form,
check to see whether the form's recordsource is based on the table or on a
query. If on a query, you'll need to add the new field to the query as well.

 

[Joseph Meehan]

Ok I have imported all my files from excel to msdb now I need to add
a field for notes in the table's, queries, etc. that I have created.
how do I do that? oh and I tried doing add a field and it adds it at
the begining of the table and i need it at the end of the table.

Tables don't have a beginning nor end. They should be considered as a
bucket of data with a list of field names written on the side in no
particular order.

You can use a query, form or report to view and edit data. You can put
the fields in any order you like and if you have the right field you can
sort the data to appear in whatever order you want.

Remember that unlike a spreadsheet each record is on its own, even if it
looks like it has an order in the table, that may change tomorow.

 

[John W. Vinson]

Ok I have imported all my files from excel to msdb now I need to add a field
for notes in the table's, queries, etc. that I have created. how do I do
that? oh and I tried doing add a field and it adds it at the begining of the
table and i need it at the end of the table.

Open the Table in design view and add the field. The order of fields in the
table is completely immaterial; you shouldn't need to worry about it (though
if you use table design view, it's easiest to add the field at the end, I have
no idea how you're doing it). Data shouldn't be viewed in table datasheets;
create a Form instead, and put controls bound to the fields wherever you like
on the Form.

John W. Vinson [MVP]