Grouping Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Is this possible?? 3
What's new today? 7
Recordset Findfirst Date Issue 0
Need help Sorting By Date Using a Formula 1
How to export table from outlook into ms access table? 0
Dates and Business days 4
Work completed 2 different dates 3
Grouping and Sorting Problems 5

Back
Top