Help
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?
Page 1 of 1
Access 03: Creating Reports w/ Filtered Dates
#1
- Distinguished Member
-
- Group: Members
- Posts: 605
- Joined: 25-October 08
Posted 26 October 2010 - 12:23 PM
Back to top
#2
- Distinguished Member
-
- Group: Members
- Posts: 670
- Joined: 12-August 08
- Gender:Male
- Location:Steel City, UK
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.
Murphy's Law: If Anything Can Go Wrong, It Will, Often At The Worst Possible Time.
“Programming Today Is A Race Between Software Engineers Stirring To Build Bigger And Better Idiot-Proof Programs, And The Universe Trying To Produce Bigger And Better Idiots. So Far, The Universe Is Winning.”
People Have The Right To Be Stupid, But Some Abuse That Privilege.
“Programming Today Is A Race Between Software Engineers Stirring To Build Bigger And Better Idiot-Proof Programs, And The Universe Trying To Produce Bigger And Better Idiots. So Far, The Universe Is Winning.”
People Have The Right To Be Stupid, But Some Abuse That Privilege.
Share this topic:
Page 1 of 1