User Friendly Search

[Jeff @ CI]

In Access 2000, I need to provide a list of reps who service a number of
cities. The search needs to be form based. The search will also need to be
based on date based events.

In imagery, they select the event city, click a button and see who is
available to service the city and thus the event. They will also need to see
who has been assigned to work that event on a click - seperate function.

I have three tables that apply. #1 has the rep's info (Name, Rep ID, etc.).
#2 has the city and state where they have indicated they will service (City,
State). #3 has the event info (City, Date, etc.). All three are linked via
the Rep ID.

I have tried to do a cross tab, but am not getting it set up right. Do I
need to do another query that brings all info into one and then do the cross
tab?

Thanks for any help.

Jeff

 

[KARL DEWEY]

All three are linked via the Rep ID.
How would the event table have Rep ID if you have not already assigned them?
Yes I think you need a query ahead of a crosstab for this.
I an not sure if a crosstab will do what you want. What would your crosstab
output look like?