parameter queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working for an engineering firm. I am doing my monthly billing by
tracking time that each engineer spent on each project during the month. At
the end of the month, I input all data from the timesheet such as project #,
project name, engineer's name, total hours. I have setup a query which gives
me a report to show each project with name of the engineer (whoever works on
that project) and how many hours he/she spent during the month (whatever the
month that I put in under "criteria"). However, for each project that
printed out, I would like to know more details about that project, such as
how many hours we have spent on that project from the beginning until that
date. Is there a way to create that kind of report?

Please help. Thanks.

Kim
 
Kim,
I'm sure there are a gazillion ways to do this. Here are some of my ideas
on how you could get the output you're seeking.

1) Create a temporary table which will hold some calculated values - the
total number of hours spent by anyone on that project from beginning to end.
2) Create a query which calculates the values and writes a record to your
temporary table. Create another query which clears all the values from
your temporary table.
3) Your report would be linked to the temporary table as well as the other
tables you normally use to create the report. You'd add some boxes to your
current report to show the values you are pulling from that temporary table.
4) Create a button which triggers the following events:
- Clear the temporary table
- Calculate the time overall and append to the temporary table
- Run your report

Hope this helps. Good luck.

Linda
 
Back
Top