Reply to thread

Message: [QUOTE="Guest, post: 6861787"] I went to this site and did what was suggested and it worked great. Did the following: Set your queries Column Headings property to: "Mth0", "Mth1", "Mth2", "Mth3",.., "Mth11" Build your report based on these "relative" months. If you need column labels in your report, use text boxes with control sources of: =DateAdd("m",0,Forms!frmA!txtEndDate) =DateAdd("m",-1,Forms!frmA!txtEndDate) =DateAdd("m",-2,Forms!frmA!txtEndDate) =DateAdd("m",-3,Forms!frmA!txtEndDate) This works fine when you use a beginning date and an end date that cover any 12 month. However if I try to run the report with from 09/01/05 to 9/30/05 my headers appear as: Oct 04, Nov 04, Dec 04, Jan 05, Feb 05...Sep 05 The data appears in the first colum Running it for 03/01/05 to 05/31/05 produces the follwing results: Jun 04, Jul 04, Aug 04, Sep 04...Dec04, Jan 05...May 05. The data appears in the first 3 columns. I have tried everything to work out the logic, but I've had no luck. Any suggiestions?? Thanks! [/QUOTE]