List Actuals w/in Date Range, and the Planned for the next month

[Jules]

I need a report that will list Actuals (date range) and Planned (next month).

For example, List the Count of People Hired from Oct 2004 through 31 Aug
2005 for each department, and the Count of Planned Hired for September 2005.

 

[John Vinson]

I need a report that will list Actuals (date range) and Planned (next month).

For example, List the Count of People Hired from Oct 2004 through 31 Aug
2005 for each department, and the Count of Planned Hired for September 2005.

How are these values stored in your tables?

A Report with two subreports based on queries with date criteria such
as

= DateSerial([Enter year:], [Enter month:], 1) AND < DateSerial([Enter year:], [Enter month:] + 1, 1)

for the current month, and

= DateSerial([Enter year:], [Enter month:] + 1, 1) AND < DateSerial([Enter year:], [Enter month:] + 2, 1)

for next month might be a start...

John W. Vinson[MVP]