parameter queries

[Guest]

I work for an engineering firm. Each engineer works on different projects
each month. However, not all projects will have time spent on everymonth.
Sometime, they spend time on one project for this month and then next month
they don't have any time on that same project, but the following month they
have time spent on that project again. I am trying to create a monthly
report which will show all projects that have time spent during that month;
and for each project on that report, I like to have a total time we have
spent todate. I am using this report for billing purposes. Is there a way to
do that kind of report? I am using Access 2003.

 

[Guest]

OK... firstly I'm ignoring he total time spent... you appear knowledgable
enough for that.

The month by month report has a simple and a better solution. I'm giving the
better one (I hope)

You need: Format(Now(),"mmm")

Which right now returns "Aug"

So in your db query you've probably got a table recording the work with its
respective date time etc... but we want just the month... and months have
anything from 29 to 31 days in them, hence the reason to just query the
month's name.

Buid the query as you'd expect BUT add a duplicate DateofWork column to the
query. You need to format this as above, if your column is called DateofWork
the column would look like this:

MonthOfWork: format([DateofWork], "mmm")

If you run it now you'll notice the column we've just created (Alias
"MonthOfWork") show just the month name when the work was carried out.

All that's left is to add the criteria to this column of Format(Now(),"mmm")

Dynamically matching the query to whatever month you run it from in the
future.

Enjoy.