Help me Plz....Sorting

[putaro]

Ok,

Thanks for reading...Well here is my problem, Is there anyway to sort
by earliest date? For example.


I have 4 colums


____________________________________
| Cust Id | Work Order | Schd Date | Tech # |
| 11111 | 1234 | 10/21/06 | 12345 |
| 11111 | 1235 | 10/28/06 | 12346 |
| 11112 | 1236 | 10/22/06 | 12347 |
| 11112 | 1237 | 10/23/06 | 12347 |
----------------------------------------------------------------

Ok so i need only the first date on each Cust id sorted to coresponding
tech #.
EXAMPLE: Tech # 12345 was first at Cust Id 11111
Tech # 12347 was first at cust id 11112

And that put on a different sheet and the techs following that first
tech be place under the first tech.
I hoped i explainded it right.

Thank you for your effort and i hope you can help me

 

[Allen Browne]

1. Create a query using this table.

2. Depress the Total button on the toolbar (upper Sigma icon.)
Access adds a total row to the grid.

3. In the Total row under Cust ID and Tech #, accept:
Group By

4. In the Total row under Schd Date, choose:
Min

Leave Work Order out of the query.
If you really did need it in there, see:
http://www.mvps.org/access/queries/qry0020.htm

 

[putaro]

1. Create a query using this table.

2. Depress the Total button on the toolbar (upper Sigma icon.)
Access adds a total row to the grid.

3. In the Total row under Cust ID and Tech #, accept:
Group By

4. In the Total row under Schd Date, choose:
Min

Leave Work Order out of the query.
If you really did need it in there, see:
http://www.mvps.org/access/queries/qry0020.htm

Thank you for you responce. But i guess i didnt explain it good enough.
I need to seperate them to corresponding tech id.

So for expample i will make several tabs under excell for each tech id.
The first technician out at this job, and then under that all jobs at
that house.

So under tab 12345 there will be all his jobs he was the first one at
and under those jobs all other techs out to the same house. Then
another tab with 12347 with the jobs he was the first one at....And so
forth.

I dont know if this can be done, but i just dont to sort by Cust ID
then by Date. And cut and paste all info. It takes a long time.

Thank you again and i hope you have a solution to my delema. If you
need a better example of the sheet i am working with i can email you an
example and you can kinda get the picture i guess.

 

[Allen Browne]

Create a report.

In a report, it's very easy to create a group header (Sorting and Grouping
box, on the View menu)