 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / June 2007Grouping Dates
Instead of having the same date 50 times on a report, how can i group it so there is only 1 date per day, instead of 50? Text boxes have a "Hide Duplicates" property. If set to yes the first instance will show, but subsequent duplicate values will not. Sounds like this will do what you want as long as your data is sorted correctly. HTH, > Instead of having the same date 50 times on a report, how can i group it > so > there is only 1 date per day, instead of 50? Awesome, Thanks! Very easy. Another problem. I have millions of rows of data. I am sorting the data on the report by Run Date and Month. I need to get the difference in product prices for every month to show on the report. How do I go about this when only one text box shows up. I cannot subtract the same text box. Thanks again! > Text boxes have a "Hide Duplicates" property. If set to yes the first > instance will show, but subsequent duplicate values will not. [quoted text clipped - 7 lines] > > so > > there is only 1 date per day, instead of 50? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.