Making monthly reports

[ctaylorhill]

Hi everyone,

I am new to this so my questions may seem obvious to some.

I am creating a fault management system as part of a project. I need to be able to create monthly reports for completed jobs and incomplete jobs.

What is the best and simplest way to say I want to create a report from the 01/01/2008 to the 01/02/2008?

As I said, I am completly new to this so please excuse my poor terminology and understand of this.

Thanks in advanced

 

[statsman]

In the query that runs your report, in the criteria for date enter the following:

Between [startdate] And [enddate] square brackets required

When you open your report, the query will prompt you for a startdate and an enddate.

Your report should reflect these dates.

As you gain more experience in Access, you can create a search form to do this for you. For example if you created a form called Report Search Form, place two blank textboxes in the form and name them startdate and enddate. You would then enter in the report query
Between [Forms]![ReportSearchForm]![startdate] And [Forms]![ReportSearchForm]![enddate]

 

[Simon_MT]

Same principle but you create a Dialog Form with the dates and use this to fire off your Monthly reporting requirements or everything centers around monthly reyuirements set up a table with your period dates included, a Current Month Flag and a Current Year Flag to trigger events. The later is ueful because you can add subforms to enquire on completed jobs and incomplete jobs.

Simon