I have a list of expriation dates that look like this for lets say 10 employees
A B C
MMD 5-25-07 Comments
First Aid 10-20-05 Comments
CPR 11-15-06 Comments
Passport 11-16-08 Comments

I want to sort each individule employee's information with the nearest
expriation date automaticly each time I access the file. I would also like
the employee's entire field to the top of the page i.e.

If Bob's field of information is at the bottom of the file but his CPR is
going to expire the soonest I want his entire field to move to the top of the
page. I don't even know if this is posible.

Hi Sean-

Terminology first... the data items in A, B, & C are the *fields*, and each
Row constitutes a *record*. So my understanding is that you want the records
to be sorted based on the ExpDate field and _don't_ want the records to get
scrambled.

Assuming the data is stored as represented in your pos, just click anywhere
in column B, then click the A-Z (Sort Ascending) button on the Standard
Toolbar. Save the file & that's the order they will be in the next time you
open it. BTW- it would be a good idea to have captions (field names) at the
top of each column of data in the row immediately above the first record.

There really isn't a need for anything more sophisticated unless others are
modifying the list of records, too, and you don't want to have to sort each
time you access the file.

If you add any additional records, type them at the bottom of the list, then
sort again to get them arranged. Likewise, if something gets 'renewed', just
sort the list again after editing the records. You might also want to take a
look at DataForm, which may prove useful to you (just make sure you select a
cell in the data range _before_ you use it, otherwise it won't do you any
good).

HTH |:)

"Sean DeBruler" wrote:

I have a list of expriation dates that look like this for lets say 10 employees
A B C
MMD 5-25-07 Comments
First Aid 10-20-05 Comments
CPR 11-15-06 Comments
Passport 11-16-08 Comments

I want to sort each individule employee's information with the nearest
expriation date automaticly each time I access the file. I would also like
the employee's entire field to the top of the page i.e.

If Bob's field of information is at the bottom of the file but his CPR is
going to expire the soonest I want his entire field to move to the top of the
page. I don't even know if this is posible.

Hi Sean:

Does Bob's name appear anywhere in the rows?
--
Gary''s Student


"Sean DeBruler" wrote:

I have a list of expriation dates that look like this for lets say 10 employees
A B C
MMD 5-25-07 Comments
First Aid 10-20-05 Comments
CPR 11-15-06 Comments
Passport 11-16-08 Comments

I want to sort each individule employee's information with the nearest
expriation date automaticly each time I access the file. I would also like
the employee's entire field to the top of the page i.e.

If Bob's field of information is at the bottom of the file but his CPR is
going to expire the soonest I want his entire field to move to the top of the
page. I don't even know if this is posible.

Thank you for the information. Sorry I don't speak the lingo so you'll have
to bare with me. I Guess I didn't explaine myself well enough. So now I
will try better. Here is what I'm dealing with.

A B C D E F G H I J K L M N O P Q
Document Orig Date Exp Date Comment
CPR 1-1-1999 1-1-2002 none
MMD 1-3-1998 1-4-2005 none
First Aid 1-3-1999 1-3-2002 none

I have lets say 10 of these what I would call a field (One for each employee)

I would like each field to sort automaticly by the Exp Date and then would
like the "fields" sorted by the Exp Date expiring the soonest.

Thank you

"CyberTaz" wrote:

Hi Sean-

Terminology first... the data items in A, B, & C are the *fields*, and each
Row constitutes a *record*. So my understanding is that you want the records
to be sorted based on the ExpDate field and _don't_ want the records to get
scrambled.

Assuming the data is stored as represented in your pos, just click anywhere
in column B, then click the A-Z (Sort Ascending) button on the Standard
Toolbar. Save the file & that's the order they will be in the next time you
open it. BTW- it would be a good idea to have captions (field names) at the
top of each column of data in the row immediately above the first record.

There really isn't a need for anything more sophisticated unless others are
modifying the list of records, too, and you don't want to have to sort each
time you access the file.

If you add any additional records, type them at the bottom of the list, then
sort again to get them arranged. Likewise, if something gets 'renewed', just
sort the list again after editing the records. You might also want to take a
look at DataForm, which may prove useful to you (just make sure you select a
cell in the data range _before_ you use it, otherwise it won't do you any
good).

HTH |:)

"Sean DeBruler" wrote:

I have a list of expriation dates that look like this for lets say 10 employees
A B C
MMD 5-25-07 Comments
First Aid 10-20-05 Comments
CPR 11-15-06 Comments
Passport 11-16-08 Comments

I want to sort each individule employee's information with the nearest
expriation date automaticly each time I access the file. I would also like
the employee's entire field to the top of the page i.e.

If Bob's field of information is at the bottom of the file but his CPR is
going to expire the soonest I want his entire field to move to the top of the
page. I don't even know if this is posible.

Gray's Student Please see reply to CyberTaz. I think I explained myself
better.
Thank You

"Gary''s Student" wrote:

Hi Sean:

Does Bob's name appear anywhere in the rows?
--
Gary''s Student


"Sean DeBruler" wrote:

I have a list of expriation dates that look like this for lets say 10 employees
A B C
MMD 5-25-07 Comments
First Aid 10-20-05 Comments
CPR 11-15-06 Comments
Passport 11-16-08 Comments

I want to sort each individule employee's information with the nearest
expriation date automaticly each time I access the file. I would also like
the employee's entire field to the top of the page i.e.

If Bob's field of information is at the bottom of the file but his CPR is
going to expire the soonest I want his entire field to move to the top of the
page. I don't even know if this is posible.