Adding a field

N

Nina

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.
 
D

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.
 
J

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.
Click to expand...

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]
 
Top