Results 1 to 1 of 1
  1. #1
    Join Date
    Dec 2003
    Location
    Seattle, WA
    Posts
    6

    Unanswered: SQL or VBA: Normalizing

    If I have a single table with the following fields:

    location, date, status, Value1, Value2, Value3, etc.

    north Jun1 Y 3 2 2
    north Jun1 N 1 1 3
    south Jun1 Y 5 2 1
    South Jun 1 N 2 1 0
    North Jun7 Y 2 3 2
    North Jun 7 N 1 1 1


    How can I use SQL or code to pull records from this table into a query and/or another table into the following format: by location and by individual Value (numbers represent the count of the values by status each week-entries are made once a week)?

    -------
    North

    Value1

    ---------- week# 1 2 3 <-Column Headings

    Row Head> # Y -- 3 2 etc
    Row Head>-#N -- 1 1 etc

    Value2

    ---------- week# 1 2 3 <-Column Headings

    Row Head> # Y -- 3 3 etc
    Row Head>-#N -- 1 1 etc


    Thanks for the help!!!
    Last edited by calstan; 12-08-03 at 01:32.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •