Multiple table query, report, and method of implementation

[Jeff Miller]

(No code of any sort follows)

Scenario:
Need to generate an annual performance report for any given employee.

Personnel are keyed by an employee number (#)

Two tables each which handle two different instances of employee number:

A Run Log which holds Driver# and Passenger#
A Maintenance Log which holds Diagnostic# and Repair#


A report should be generated that does not differentiate time spent as Driver from Passenger, but should differentiate Diagnostics and Repairs, to give the totals of all three.

I may be overcomplicating this and simply using three different queries and using a count function on the query call in the form may be enough (and tell me if this is the case), but there is a more complicated part of it that I am absolutely unsure of how to implement.

There is an asset inspection team that rotates out on a regular basis, but sometimes pulls people back into it.

What is a method to be able to simply track an indviduals time as part of the inspection team and then use it as a query to add that to the annual report without requiring individually tailored query information?

Alternatively, how can I use a text box to pull from a field that holds the dates to indicate to the user what dates must be selected, and is there any better way to hold these dates than allow a memo field to be appended indefinitely to hold all dates?

And, further on that, is there any way to allow a user to simply select multiple date ranges?

I can accomplish all of the above in extremely obtuse manners, but I'm trying to avoid heading on that path.