History Data in Access 2003 Report

[ElTipo]

Hello People,

I need some help,

I need to know how I made a report with old data like a history data. For example if you need to see anual data from 1/1/06 to 12/31/06 for any amounts. If any know a site for reports examples please let me know.

Thanks!!

[jaxjagfan]

Hello People,

I need some help,

I need to know how I made a report with old data like a history data. For example if you need to see anual data from 1/1/06 to 12/31/06 for any amounts. If any know a site for reports examples please let me know.

Thanks!!

Within the criteria of your reports datasource you need to use BETWEEN.

If the report is based on a query the sql would look something like this:

Select qryHistoryRpt.* WHERE qryHistoryRpt.MyDate BETWEEN #1/1/2006# AND #12/31/2006#