By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,946 Members | 1,714 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,946 IT Pros & Developers. It's quick & easy.

History Data in Access 2003 Report

P: 36
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!!
Feb 20 '08 #1
Share this Question
Share on Google+
1 Reply


jaxjagfan
Expert 100+
P: 254
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:

Expand|Select|Wrap|Line Numbers
  1. Select qryHistoryRpt.* WHERE qryHistoryRpt.MyDate BETWEEN #1/1/2006# AND #12/31/2006#
  2.  
Feb 20 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.