I am trying to create a db to help me with a federal grant report. I
arrange for contractors to work with individual clients. The only info I
have on the contractors at this point is basic contact info. The client
form has a place to enter client number and contractor working with that
client. Then there is a subform to enter the date, activity, time and cost
for the project. This is linked to the individual client. I have then
created a query that summarizes the total time and cost for the client's
project onto the client form.
When I report to the feds, I need to be able to provide a number relatively
close (i.e. equal) to the number of Full Time Employees it would take to do
the work. So I need a query and/or report that will let me enter the start
date and end date of the reporting period and then it will provide a total
number of hours worked during that period.
Can anyone give me some direction in how to go about setting this up?
Thanks for the help in advance.
----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----