Grouping Dates

T

trs9385

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?
 
G

George Nicholson

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,
 
T

trs9385

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!
 
Top