G
Guest
Hi
I'm an Access newbie. I have a sales table that has sales date for the last
4 years. I need to create a crosstab query by month for 3 years. The col
headings would be Jan 2003, Jan 2004, Jan 2005, Feb 2003 etc. When I use the
format function to display both month and year, then the months are sorted
alphabetically.
Any ideas?
Thanks
Heather
I'm an Access newbie. I have a sales table that has sales date for the last
4 years. I need to create a crosstab query by month for 3 years. The col
headings would be Jan 2003, Jan 2004, Jan 2005, Feb 2003 etc. When I use the
format function to display both month and year, then the months are sorted
alphabetically.
Any ideas?
Thanks
Heather