I have a dataset with 6 dates where the dates are crosstabled. When I do a count on datefield, count(datefield), I get a count over 100. Is there any way to only get a count of 6, for 6 days?
Perhaps count(distinct datefield). If not you'll have to give more information about your dataset.
Try to use DISTINCT in Count function.
Retrieving data ...