YTD + period reports

[tim.schuffelen]

Hi all,

I've got a problem, as an intern my assignement is to rebuild/edit an
MS access database. This database system is used to create reports to
send to the 'customers'.

There are 2 sorts of reports, a report including only YTD numbers (no
period numbers), the year to date numbers are calculated per project.
Whenever a new record is added it will have to be SUM'd with the
existing records in the report.. this WORKS..

And there is a period report, a report that only includes the projects
that were done in the period selected, this period is being selected
before you press the 'print button' you fill in the startdate / enddate
and the periodname and then it should show you only the records added
in the period.

All added records have a creation date so the thing that should be done
when pressing the print button is looking the creation date up and look
if it fits between the period date selected at that moment. I
absolutely do not know how to get this done.

Thanks all of your effort in advance,

Tim

 

[Lynn Trapp]

Build your reports off of a query that has criteria for the periods you
need. Something like this.

YTD:

WHERE Creation_Date >= #1/1/2006# AND Creation_Date <= Date()

PERIOD:

WHERE Creation_Date >= [Begin Date] AND Creation_Date <= [End Date]