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

summary by date range

P: n/a
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 =----
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You need the following tables:
TblContractor
ContractorID
<name and basic contact info>

TblClient
ClientID
<name and contact info>

TblProject
ProjectID
ContractorID
ClientID

TblProjectDetail
ProjectDetailID
DetailDate
DetailActivity
DetailTime
DetailCost

Your client form should be a project form/subform. The main form is based on
TblProject and the subform is based on TblProjectDetail.

For your report to the feds, create a query based on TblProjectDetail.
Include only the DetailDate and DetailCost fields. Set the criteria for the
DetailDate field to: Between [Enter Reporting Period Start Date] And [Enter
Reporting Period End Date]. Click on the Sigma (looks like capital E) button
on the toolbar at the top of the screen. Change Group By under DetailDate to
Where. Change Group By under DetailCost to Sum. When you run this query, the
total cost will be shown as SumOfDetailCost.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

If you don't get the help you need in the newsgroup, I can help you for a
very reasonable fee.
Over 1000 Access users have come to me for help.
Remember that a lone man built the Ark. A large group of professionals built
the Titanic.

"Robert" <sanfordlaw@***inebraska.com> wrote in message
news:11*************@spool6-east.superfeed.net...
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
=----

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.