I have 3 columns. How do I sort all 3 of them by 1 column?

[Guest]

There are 3 colums:

EMPLOYEE NAME DEPT. CAMPUS
ex:
Doe, John Maintenance North Campus
Jones, John Math Central Campus
Sanchez, Heather English South Campus
Smith, Joe Admissions Central Campus
etc......

I have a table and I want to sort the 3,000 records by which campus they are
from instead of alphabetically by employee name ...how do I do that?

Thank you.
This would help me alot.

 

[Rick B]

In your query, form, or report, just set that field as your sort.

The order of the records in the table is unimportant. You should not work
in the tables - they are simply buckets for holding the data.

FYI - you should think about changing your table a bit. I would probably
not store the names like that. I'd use a separate FirtName and LastName
field. This will offer you the flexibility to print only first name, first
then last, last comma fist, etc.


--
Rick B



"Sorting records with 3 columsby 1 column" <Sorting records with 3 columsby
1 (e-mail address removed)> wrote in message
news[email protected]...

 

[Joseph Meehan]

There are 3 colums:

EMPLOYEE NAME DEPT. CAMPUS
ex:
Doe, John Maintenance North Campus
Jones, John Math Central
Campus Sanchez, Heather English
South Campus Smith, Joe Admissions
Central Campus
etc......

I have a table and I want to sort the 3,000 records by which campus
they are from instead of alphabetically by employee name ...how do I
do that?

Thank you.
This would help me alot.

Assuming you are using Access database, you sort in a query, report or
form. You don't sort in a table, which is just a bucket of data. Rick
explained how to do it. If you still have a question let us know.

However it sounds like you may be using an spreadsheet like Excel. If
that is the case they the answer is different and you should ask your
question in an Excel newsgroup.

Good Luck.

 

[Guest]

While the table in design view, open the table proprties (in the menu bar
select View > properties) in the Order by section write the name of the field
you want to sort by.
but remember that it can change every time you change the sort while the
table is open, and then you save the layout.

So, I would use a query to do that for me

 

[aaron.kempf]

yeah it kinda sounds to me like you're using excel or something

are you using access?

 

[Guest]

I don't think I explained it well before. The file is an Excel file right
now, but I want to make it an Access query, form, or report....(don't know
which one would be better).
I have 3,000 record like listed below, but I onlywant to take out the whole
records with name, dept, and all that have Central campus, leaving the other
two campus's. How would I do that, and in which type of Access file would
work best.

 

[John Vinson]

I don't think I explained it well before. The file is an Excel file right
now, but I want to make it an Access query, form, or report....(don't know
which one would be better).
I have 3,000 record like listed below, but I onlywant to take out the whole
records with name, dept, and all that have Central campus, leaving the other
two campus's. How would I do that, and in which type of Access file would
work best.

You can use File... Get External Data... Import to import the
spreadsheet data into an Access Table, or File... Get External Data...
Link to leave the data in Excel and link to it.

Either way, you can then create a Query with a criterion of "Central
Campus" on the Campus field to select only records from that campus.
Note that "selecting" records and "sorting" records are two different
operations; it sounds like you're using the term "sort" in both
senses.

Once you have the data in a table (linked or imported, either way) you
can create Queries to either select (choose which records you want to
see) *or* sort (put those records in alphabetical order) - or both! -
on any field or combination of fields.

John W. Vinson[MVP]

 

[Guest]

Could you use lamon (step by step) terms, I'm not too familiar with Access.

Sorry.

Thank you so much.

 

[John Vinson]

Could you use lamon (step by step) terms, I'm not too familiar with Access.

Open Access.

On the Menu select the "File" menu option. On the dropdown list,
select "Get External Data". Select Import from the flyout choices.

A screen will come up; select "Excel" on the dropdown for "Files Of
Type". Use the file list to navigate to your spreadsheet.

Follow the instructions provided by the import wizard.

This will create a new Access Table containing all of the data in the
spreadsheet.

Now, create a new Query. Select the table name; include all of the
fields. On the Criteria line under Campus type

"Central"

Save this query as "qryCentral".

Finally, use the Report Wizard to create a Report based on this query.

John W. Vinson[MVP]