Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Access 20
0 views
Skip to first unread message
dave s
Jul 14, 1998, 3:00:00 AM7/14/98
to
> I have an Access 2.0 database which contains the names of customers assigned to staff. Customers are listed alphabetically and need to be reassigned among the staff.
> I need a report that will extract the new re-assigments for each staff member and list them on a separate line-- the first and last person assigned to the staff member(knowing in advance how many each staff member will receive). For example, the customer names includes AArons, Abraham, Adams, Bailey, Baker, Bowling, Brigget, and Cash. The staff are Cunningham, and Dotson. Since each staff person gets 4 customers, and I need the first and last customer for each staff person listed on a separate line, the list should look like:
>
> AArons, Bailey
> Baker,Cash
>
> A preferred look would be:
>
> Cunningham-AArons, Bailey
> Dotson-Baker,Cash
>
>
> Thanks for any help!
>
> I need a report that will extract the new re-assigments for each staff member and list them on a separate line-- the first and last person assigned to the staff member(knowing in advance how many each staff member will receive). For example, the customer names includes AArons, Abraham, Adams, Bailey, Baker, Bowling, Brigget, and Cash. The staff are Cunningham, and Dotson. Since each staff person gets 4 customers, and I need the first and last customer for each staff person listed on a separate line, the list should look like:
>
> AArons, Bailey
> Baker,Cash
>
> A preferred look would be:
>
> Cunningham-AArons, Bailey
> Dotson-Baker,Cash
>
>
> Thanks for any help!
>
0 new messages