By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,251 Members | 2,727 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,251 IT Pros & Developers. It's quick & easy.

Multiple table query, report, and method of implementation

P: 4
(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.
Mar 14 '11 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.