Can't get access to update table with specific data

[jtilley23]

I'm having a serious issue trying to combine the data from two tables togeather for an installation schedule . I have tables that have the following.

ROUTING INFO TABLE
Date:
Start Time:
Address:
Time Needed for Install:
Time to Next Install:

TECH INFO TABLE
Tech #:
Tech Name

I can't get access to assign jobs based on when the time to next install is available.
I would like for access to assign 10 tech numbers for installs automatically so that it will give the time need for a job before assigning the techs to another job. Do I have to use an update query with specific criteria. I'm so stumped. Any help would
be greatly appreciated. Thanks.

 

[dhookom]

First of all, I don't see how these two tables are related. Second, you have a lot of work to do to write some specs that hold water. Which tech gets assigned first? Do you work nights and weekends? How about holidays?

I expect any solution might require some coding. PHV, Golom, and others get quite fancy with SQL but I have might doubts about a pure sql solution.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]