Re: Changing Query Layouts

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 09/16/04 

Date: Wed, 15 Sep 2004 23:04:34 -0500

Whenever you post something like "with no success", it should be followed
with what you did (in this case your sql) and what the resulting error was. 

-- 
Duane Hookom
MS Access MVP
"Tom" <anonymous@discussions.microsoft.com> wrote in message
news:2b3e01c49b32$8bd26cb0$a301280a@phx.gbl...
> Sorry!  I hadn't meant to post to different newsgroups, I
> just thought I had put my original post in the wrong one
> and didn't know if I could delete it off.
>
> I have tried the Union query you suggested, but with no
> success.  Is it easier to do it as a Union query rather
> than a Crosstab?  I have very limited SQL knowledge, and I
> think that is what is causing the problem as I can't apply
> the code you have given to my query, I just generate
> errors.
>
> I appreciate your help on this,
> tom
>
>
> >-----Original Message-----
> >At least one other reply in another news group. Please
> don't post to
> >multiple news groups.
> >
> >-- 
> >Duane Hookom
> >MS Access MVP
> >--
> >
> >"Michel Walsh" <vanderghast@VirusAreFunnierThanSpam>
> wrote in message
> >news:eQOtc2wmEHA.3608@TK2MSFTNGP09.phx.gbl...
> >> Hi,
> >>
> >>
> >>     Use a crosstab query.
> >>
> >>
> >>     TRANSFORM SUM(Sales)
> >>     SELECT Null]
> >>     FROM MyTable
> >>     GROUP BY  Null
> >>     PIVOT [Month]
> >>
> >>
> >>
> >> Hoping it may help,
> >> Vanderghast, Access MVP
> >>
> >>
> >>
> >> "Tom" <anonymous@discussions.microsoft.com> wrote in
> message
> >> news:272d01c49aff$ae5b1800$a501280a@phx.gbl...
> >> > Is it possible to change a query's layout?  If so,
> how can
> >> > I take a query that has Coloumns (across the top) and
> make
> >> > them rows in a table?  For instance, I have Apr, May,
> June
> >> > etc. along the top with a Sales figure below it.  How
> do I
> >> > create a table that takes these column headings and
> >> > arranges them into one column entitled "Month"?  e.g.
> >> >
> >> > Month          Sales Figure
> >> > Jan               1
> >> > Feb               1
> >> > Mar               1
> >> > Apr               1
> >> >
> >> > Thanks for any help on this!
> >> >
> >> > Tom
> >>
> >>
> >
> >
> >.
> >

Relevant Pages

  • Re: Simulating A Full Outer Join in Access from 3 Tables
    ... task unless you have advanced knowledge of VBA and or Jset SQL DDL. ... you can use the union query you have to load the dates. ... and using the date feild as the basis to align ... What I'm seeking to do is consolidate the files into one so ...
    (microsoft.public.access.queries)
  • Re: Submit Form Elements to Insert Multiple Records into a Database
    ... > response...wouldn't your solution just append each set of values to ... > each other causing the insert statement to feed in one long string of ... The derived_table is any SQL statement that returns a dataset that matches ... UNION query portion of the INSERT statement into Query Analyser. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Union fields in the order they appear in the table
    ... with SQL, and do not know where I am going wrong. ... "John W. Vinson" wrote: ... populate the table based on the UNION query; be sure that there is a nonunique ...
    (microsoft.public.access.queries)
  • Re: Simulating A Full Outer Join in Access from 3 Tables
    ... It would be a combination of SQL controlled by VBA. ... destination table and the number of columns is not the same, a Union query ... "I would link each file individually and use an append query for each ...
    (microsoft.public.access.queries)
  • Re: Changing Query Layouts
    ... I have tried the Union query you suggested, ... >At least one other reply in another news group. ... >> Use a crosstab query. ... >> Vanderghast, Access MVP ...
    (microsoft.public.access.queries)