Re: Crosstab in reverse

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Douglas J. Steele (NOSPAM_djsteele_at_NOSPAM_canada.com)
Date: 07/16/04 

Date: Fri, 16 Jul 2004 17:52:48 -0400

Try a union query:

SELECT [RA Number], ProductID, "Sm" As Size, Sm
FROM MyTable
UNION ALL
SELECT [RA Number], ProductID, "Med" As Size, Med
FROM MyTable 

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Bill" <anonymous@discussions.microsoft.com> wrote in message
news:2e9d201c46b7e$6e724390$a501280a@phx.gbl...
> I am trying to create a query that will do the
> following...
>
> Turn this:
>
> RA Number     ProductID     Sm     Med
> 245           00000456       12     12
>
> Into this:
>
> RA Number     ProductID     Size     Qty
> 245           00000456       Sm      12
> 245           00000456       Med     12
>
> Any Ideas?
>
>

Relevant Pages

  • Re: Different RowSource for a Combo Box in a Datasheet for each row?
    ... Different RowSource for a Combo Box in a Datasheet for each row? ... So you need to start with a union query of those 4 tables. ... If each table only has 1 productID, ... If you have a mapping table, just join the mapping table to ...
    (microsoft.public.access.formscoding)
  • RE: Before, current, and ending units based on dates
    ... ProductID UnitPrice BB Rec Inst EB (Abbr. ... I believe it has something to do with the Union query not grouping. ... > to show the beginning balance, and the footer for the productid where you'll ...
    (microsoft.public.access.reports)
  • Re: Adding an asterisk to the list of items already in a combo box
    ... Doug Steele, Microsoft Access MVP ... (no e-mails, please!) ... > Value List) in a combo box by using a UNION query in the rowsource ... > to append the items already in the list with an asterisk as the first ...
    (microsoft.public.access.developers.toolkitode)
  • Re: Referential integrity?
    ... If so, Rick's suggestion of the BeforeUpdate event procedure of the subform, and the RowSource of the ProductID combo sound good. ... > DetailedOrder. ... In that case having a Type field in the order ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Convert table to another table
    ... >Create a Union query on your table. ... >Doug Steele, Microsoft Access MVP ... >(no e-mails, please!) ...
    (microsoft.public.access.tablesdbdesign)