Calculate Unique Date Value

[Maverick_777]

Hello everyone,
I need to calculate the number of unique dates found within a report so I can calculate the number of stops per day. The date column has:
9/1/2011
9/1/2011
9/1/2011
9/1/2011
9/1/2011
9/1/2011
9/2/2011
9/2/2011
9/2/2011

The results should count that there are 2 unique dates in the section header of this report.

I would appreciate any thoughts or assistance you all might have...

 

[Joe4]

Subreports can be a little tricky, depending on where you put them in your report, and how you link it to your main report (if at all). Have you worked with Subreports before? If not, you may want to look at Access'built-in help files or find some on-line tutorials to help with the finer points of using Subreports.

The first thing to check is to make sure if you run the Subreport by itself (separate from your Main form) is that it returns the values you expect. If not, then that is where you need to start.