I am trying to do a comparison report showing customers for three years, however, I getting the same answer for each period. Any tips for building such a report.
Thanks.
I am trying to do a comparison report showing customers for three years, however, I getting the same answer for each period. Any tips for building such a report.
Thanks.
What are you comparing - count?
Review http://allenbrowne.com/subquery-01.html#YTD
What method are you using - subqueries, domain aggregate, subreports?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.