pivoting issue

From: Miguel Salles (MiguelSalles_at_discussions.microsoft.com)
Date: 10/04/04

  • Next message: Dan: "Consolidate Rows on Select" 
    Date: Mon, 4 Oct 2004 10:59:04 -0700

    Hi,

    I have a expenses table, in this table I have the account, exp_date,
    exp_type and amount fields.

    I have three exp_type (real, budget and myu) I would like to create a table
    with
    the fileds account, year_month, real_amount, budget_amount and myu_amount.

    I am kind of lost now. How can I do this?

    Will it be a query?
    do a have a ETL process if yes, how will it work?

    Thanks

  • Next message: Dan: "Consolidate Rows on Select"

    Relevant Pages

    • Re: auto fill data into one table based on data from a linked tabl
      ... The Budget table contains the budget name, ... Account and account detail are almost the same but the ... "Jeff Boyce" wrote: ...
      (microsoft.public.access.forms)
    • Re: auto fill data into one table based on data from a linked tabl
      ... Budget Name -Primary Key ... Account Number ... "Jeff Boyce" wrote: ... Account and account detail are almost the same but the ...
      (microsoft.public.access.forms)
    • Re: auto fill data into one table based on data from a linked tabl
      ... The budget name is what links the tables together, ... Account and account detail are almost the same but the account ... Using these lookup fields in tables will cause you considerable ...
      (microsoft.public.access.forms)
    • Re: Copy on change of value
      ... The formulas are in Sheet "ImportDataATWS" creating the data to suit our ... Account Date Amount ... Account numbers start at row 6. ... You can see why I would want to automate the import of the budget data so ...
      (microsoft.public.excel.misc)
    • Re: Copy on change of value
      ... Account Date Amount ... Assume unique accounts running in A2 down in sheet: Budget ... to suit the location of the top data cell in Budget's col A. ... I wish to copy each account number from the worksheet "Budget" to another ...
      (microsoft.public.excel.misc)