Re: Create a crosstab query grouped by month over 3 years

The 'ColumnHeadings' property of the crosstab query can help.

The drawback is that you have to enter every possible value from Jan 2001 to
Dec 2005. If the query has to slide across a four year period,(i.e. Go back
4 years from any given current day or month), then this becomes a real
maintenance problem. But, like all things in Access, if there's a problem,
VBA can solve it.

So, try the property, and post other questions if needed.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
Consulting@xxxxxxxxxx
www.fmsinc.com/consulting

"HEather" <HEather@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1FF37037-AF8C-4F0B-87F4-1C0F6B26B123@xxxxxxxxxxxxxxxx
> 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


.

Relevant Pages

  • Report with Crosstab query not working
    ... I have a report that pulls all sales using a crosstab query to show the data ... but when I put in the criteria field the following sintax it ... FROM [Sales by Everything] ...
    (microsoft.public.access.reports)
  • Re: Optional grouping of a report
    ... For the report to work properly, I think I would have to remove the ... I have listed the SQL code for both my base query and crosstab query. ... Transaction Date], tblEPOSSales.[BIS Sales Quantity], tblEPOSSales.[BIS Sales ... GROUP BY qryEPOSSalesByProduct.[D/S/S Department Code], ...
    (microsoft.public.access.modulesdaovba)
  • Re: Create a crosstab query grouped by month over 3 years
    ... > I have a sales table that has sales date for the last 4 years. ... The format function is ok for the column headings. ... property of the crosstab query in the properties window: ...
    (microsoft.public.access.queries)
  • RE: Report of sales by month based on a cross tab query
    ... You can set the Column Headings property of the crosstab query to include all ... Microsoft Access MVP ... I have a cross tab query that will provide sales by month for 2008. ... report and add the new month. ...
    (microsoft.public.access.reports)
  • Re: Last one
    ... In the crosstab query you can specify the field nameusing an In clause ... the values being the number of sales, if there are industries or sales ... crosstab query (or eventually, in the report) ...
    (microsoft.public.access.queries)