wondering how to update...please help!!!

  • Thread starter Thread starter Discojennie1
  • Start date Start date
D

Discojennie1

This is my first time making a database. I want to know how to update the
records. For example, its for a church and I want to add new families when
they join and I cannot figure out how to add in a new line in between. I want
to keep it in alphabetical order and I cannot figure out how to add in
information in between. I know how to update existing information but to add
completely different information doesn't seem to be working. I do not want to
add new columns, just add another line of information but not at the end
because it would not be in alphabetical order then. Hopefully that makes
sense. It's in a datasheet view. I'm not sure if that matters or not.
 
Tables just hold data like a bag of marbles. If you want to see records in
some set order, you need to use a query, form, or report where you can sort
the data on certain columns.
 
So, to implement what Jerry said, let's say that you want to sort by a field
named "LastName"

Use the New Query Wizard

Select your table, and then select all of the fields that are in it. Follow
the wizard through. At the end name your query "MyNewMainView"

Open the query in design view. Click on the whit sapce in the "sort" row in
the "LastName" colum (field) . rom the dropdown list choose "ascending"

Now switch from the design mod to the "view mode" . Your new query is not a
"window" to your data that automaticall sorts all records ("rows") (including
any that you add) by LastName

Good Luck in your new adventure
 
Reposting with my significant typos fixed

So, to implement what Jerry said, let's say that you want to sort by a field
named "LastName"

Use the New Query Wizard

Select your table, and then select all of the fields that are in it. Follow
the wizard through. At the end name your query "MyNewMainView"

Open the query in design view. Click on the whit sapce in the "sort" row in
the "LastName" column (field) . from the dropdown list choose "ascending"

Now switch from the design mode to the "view mode" . Your new query is now a
"window" to your data that automaticall sorts all records ("rows") (including
any that you add) by LastName

Good Luck in your new adventure
 
Back
Top