Report by Month

[Rupert Street]

I would like to set up a command button on a timesheet form to preview
the jobs a contractor has worked on for the month. I would like if
possible when the button is clicked for it to ask for the month by
name - not the starting and ending dates of the month. Is this
possible and how can I go about setting it up?

[Rog]

Rupert Street wrote:

I would like to set up a command button on a timesheet form to preview the jobs a contractor has worked on for the month. I would like if
possible when the button is clicked for it to ask for the month by
name - not the starting and ending dates of the month. Is this
possible and how can I go about setting it up?

Rupert:

Use a combo box which lists the month names spelled out: January,
February, etc. Then in an underlying query compare the user's
selection with the dates worked, formatted as "mmmm".

Rog

[Boiled egg]

Will the button fire up a report/form based on a query?
If so it is quite straight forward, you just need to add two columns to
your underlying query using the query builder.
I have called the date field JobDate - wherever you see this substitute
the name of the field in your database.
First column to add:
In 'Field' put:
SetMonth: Format([JobDate], "mmmm")
In 'Criteria' put:
[Enter month name in full]
This will return all of the jobs done in the month you specify - but it
will also return jobs from previous years. So you need to add
something to specify the year, eg another column:
In 'Field' put:
SetMonth: Format([JobDate], "yyyy")
In 'Criteria' put:
[Enter year]

Hope this helps. If this is not the answer you are looknig for, post
more details, as what you are wanting to achieve is possible.