Jump to content


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.

Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.


Access 03: Creating Reports w/ Filtered Dates

  • Please log in to reply
1 reply to this topic

#1 DnDer


  • Members
  • 646 posts
  • Local time:09:06 AM

Posted 26 October 2010 - 12:23 PM

I have an inventory list with the dates each item in the inventory has been purchased. I'm being requested to generate a report that lists items only purchased in 2006 and earlier.

The only type of report I've been able to generate is the one that has ALL the inventory, with ALL the dates. How do I narrow my report to only show items with a value in the date column of 12.31.2006 and earlier?

BC AdBot (Login to Remove)


#2 woodyblade


  • Members
  • 670 posts
  • Gender:Not Telling
  • Local time:03:06 PM

Posted 04 November 2010 - 06:25 PM

Don't know if your still looking for a solution for this, but a way to filter dates would be to create a query and then base a report on that query. By putting the column data you want in the query, then enter the Query design view and add either < 01/01/2007 or <= 31/12/2006 under Criteria of the date column you want to filter, that should give you what's needed.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users