Re: Can't get crosstab query to work right
From: Duane Hookom (duanehookom_at_NoSpamHotmail.com)
Date: 12/29/04
- Next message: Guy Story: "Re: getting a query to ask until seeing a null"
- Previous message: MarkD: "Re: Can't get crosstab query to work right"
- In reply to: MarkD: "Re: Can't get crosstab query to work right"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 29 Dec 2004 14:52:50 -0600
That's the method I would use.
-- Duane Hookom MS Access MVP -- "MarkD" <anonymous@discussions.microsoft.com> wrote in message news:04fc01c4ede7$ee244840$a401280a@phx.gbl... > Hi Duane, > > I'll google that information, thanks. And yes, I do want > to add the missing region, I just didn't know to get that. > I guess what I have to do is get REGION from the region > table, and use the relative column headings method to get > the YYYYMM columns. > > Thanks, > -Mark > >>-----Original Message----- >>Use relative column headings. You can search google > groups on my name and >>"Mth0". If you don't find the solution, come on back. >> >>I thought you wanted add back the missing region to your > completed crosstab? >> >>-- >>Duane Hookom >>MS Access MVP >>-- >> >>"MarkD" <anonymous@discussions.microsoft.com> wrote in > message >>news:0f8401c4edd8$f7eba170$a501280a@phx.gbl... >>> Hi Duane, thanks for the reply >>> >>> Since the column headings will change monthly (it's a >>> rolling 13 month crosstab), how do I change the column >>> headings? I can't use the [TableA].* since that has the >>> missing region. >
- Next message: Guy Story: "Re: getting a query to ask until seeing a null"
- Previous message: MarkD: "Re: Can't get crosstab query to work right"
- In reply to: MarkD: "Re: Can't get crosstab query to work right"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
