|
|
|
Access Database - moving text to another line |
|---|
| message from mediapressint on 5 May 2004 |
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!
|
| DDM replied to mediapressint on 5 May 2004 |
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.
|
| Kevin3NF replied to mediapressint on 5 May 2004 |
If you are talking about the order of the data in the table, it doesn't
matter. Use a query with a sort order of ascending on the name column to
present the data to the user.
|
| DDM replied to mediapressint on 5 May 2004 |
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.
|
| DDM replied to mediapressint on 5 May 2004 |
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.
|
|
