Historical Data for comparison

  • Thread starter Thread starter Scot Dever
  • Start date Start date
S

Scot Dever

is there a way to run either a query or report that returns a series of dates
each month but rather than simply reporting what is currently in the fiels
also report the previous 12 months of information for the same fields. ex
Start Construction Current for each month Jamuary through December.
 
is there a way to run either a query or report that returns a series of dates
each month but rather than simply reporting what is currently in the fiels
also report the previous 12 months of information for the same fields. ex
Start Construction Current for each month Jamuary through December.

Sure. How you would write the query depends on the structure of your table and
where the date value is stored.

If you want separate listings of this month and the previous months, you may
want to use two different queries (perhaps displayed as two Subreports on a
Report).

More details?
 
Back
Top