Access Database - moving text to another line

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I'm in a pinch. I created a database of names, address,
phone numbers etc. However, as I compiled the
information, I didn't place the names in alphabetical
order because we simply typed in the information listed.
I now want to place the names in alphabetical order. How
do I go about moving text from one line to another. I
tried to cut and paste the information. When I
highlighted and cut the info. a box popped up stating are
you sure you want to delete this? When I attempted to
copy and paste the information, the info. wouldn't fit in
the pasted box. I'd appreciate any suggestios or
instructions. I'm on a deadline. Many thanks!
 
Of course you didn't enter the names alphabetically! No one ever does. We
enter the data as it becomes available to us, in whatever order. The order
of the records in a table doesn't really matter.

Now, what were we talking about? Oh yes. Sorting names.

First of all, please tell me you entered last and first names in separate
fields (columns). You did? Good! (If you didn't, post back). Now, let's
create a query.

In the database window, click the Queries icon to switch to queries.
Double-click "Create query by using wizard" to launch the Simple Query
Wizard, and work your way through the wizard to create a simple query based
on your names and addresses table. Be sure to include all the fields and
just take the defaults on everything else. When you're done, you should have
a screen that is a mirror-image of your table, with the names in the same
order.

Now, from the query screen, pull down the View Menu and select Design View
to bring up the query design. Find the white grid down at the bottom of the
screen. Find the Last Name (or whatever it is you called your last name
field) column in the grid. Find the Sort row in that column and click it.
When the arrow button appears, click it and select Ascending. Do the same
for the First Name Field. (By the way, please tell me your last name field
is to the left of your first name field!)

Now pull down the View menu and select Datasheet View. There! Your names
should be sorted alphabetically by last name and first name. Hit the save
button on the toolbar to save this view, and just work from it from now on.
Don't even use the table any more. Enter everything here. You'll find the
names sorted alphabetically every time you open the query.
 
Of course you didn't enter the names alphabetically! No one ever does. We
enter the data as it becomes available to us, in whatever order. The order
of the records in a table doesn't really matter.

Now, what were we talking about? Oh yes. Sorting names.

First of all, please tell me you entered last and first names in separate
fields (columns). You did? Good! (If you didn't, post back). Now, let's
create a query.

In the database window, click the Queries icon to switch to queries.
Double-click "Create query by using wizard" to launch the Simple Query
Wizard, and work your way through the wizard to create a simple query based
on your names and addresses table. Be sure to include all the fields and
just take the defaults on everything else. When you're done, you should have
a screen that is a mirror-image of your table, with the names in the same
order.

Now, from the query screen, pull down the View Menu and select Design View
to bring up the query design. Find the white grid down at the bottom of the
screen. Find the Last Name (or whatever it is you called your last name
field) column in the grid. Find the Sort row in that column and click it.
When the arrow button appears, click it and select Ascending. Do the same
for the First Name Field. (By the way, please tell me your last name field
is to the left of your first name field!)

Now pull down the View menu and select Datasheet View. There! Your names
should be sorted alphabetically by last name and first name. Hit the save
button on the toolbar to save this view, and just work from it from now on.
Don't even use the table any more. Enter everything here. You'll find the
names sorted alphabetically every time you open the query.
 
Of course you didn't enter the names alphabetically! No one ever does. We
enter the data as it becomes available to us, in whatever order. The order
of the records in a table doesn't really matter.

Now, what were we talking about? Oh yes. Sorting names.

First of all, please tell me you entered last and first names in separate
fields (columns). You did? Good! (If you didn't, post back). Now, let's
create a query.

In the database window, click the Queries icon to switch to queries.
Double-click "Create query by using wizard" to launch the Simple Query
Wizard, and work your way through the wizard to create a simple query based
on your names and addresses table. Be sure to include all the fields and
just take the defaults on everything else. When you're done, you should have
a screen that is a mirror-image of your table, with the names in the same
order.

Now, from the query screen, pull down the View Menu and select Design View
to bring up the query design. Find the white grid down at the bottom of the
screen. Find the Last Name (or whatever it is you called your last name
field) column in the grid. Find the Sort row in that column and click it.
When the arrow button appears, click it and select Ascending. Do the same
for the First Name Field. (By the way, please tell me your last name field
is to the left of your first name field!)

Now pull down the View menu and select Datasheet View. There! Your names
should be sorted alphabetically by last name and first name. Hit the save
button on the toolbar to save this view, and just work from it from now on.
Don't even use the table any more. Enter everything here. You'll find the
names sorted alphabetically every time you open the query.
 
Back
Top