to create a cross tab query manualy on dates that you want groupped in months or quarters: use an expression as column headings.

 Month: Format([saleDate];”mmm”) or Format([saleDate];”q”).

If the months don’t come out in the right order, you can always rearrange manually.

Leave a Reply

Your email address will not be published. Required fields are marked *

Χρησιμοποιούμε Cookies. Με την περιήγησή σας σ'αυτόν τον ιστότοπο αποδέχεστε την χρήση Cookies.