Re: Can't run the query I need... table setup wrong?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: [MVP] S.Clark (steve.clark_NOSPAM_at_FMSInc.com)
Date: 03/17/05 

Date: Thu, 17 Mar 2005 14:26:36 -0500

You don't want to hear this, but I'll say it anyway. Start over. You'll
spend 5x the amount of time trying to fit the square peg into the round
hole.

$0.02, don't spend it all in one place. 

-- 
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting
"M S" <ms@mpscan.com> wrote in message 
news:OqTXyVxKFHA.4032@TK2MSFTNGP14.phx.gbl...
> SCOREID SKILL1 SKILL2 SKILL3
> 1         100     60     100
> 2         60      60     100
> 3         100     100     60
>
> I have the table above. I think I set it up wrong, and it should be
> something like this:
>
> SCOREID SKILLID SCORE
> 1         1     100
> 1         2     60
> 1         3     100
> 2         1     60
> 2         2     60
>
> My issue is that I have designed so many input screens around how it is
> setup now, that I really can't go back and start from scratch.
>
> Is there a query that I can do or run take will extract all the field 
> names
> and get them as values, so I can more easily report on the table? i.e., I
> need a crosstab with each SKILL down the left and the average as the 
> value.
>
> See what I am saying?  Thanks for your help!
>
> -Mike
>
>
>

Relevant Pages

  • Re: Software to create an E-book?
    ... > There is no way of telling that in an HTML document. ... > font, the amount of zoom, etc. ... How many lines can you fit on that screen? ... doing a book HTML, I want as much of the content on a single ...
    (comp.os.linux.misc)
  • Re: Astra fog lights
    ... were saying: ... Fit enough generic bits to ... cope with either, with only a small amount of tinkering required on ...
    (uk.rec.cars.maintenance)
  • Re: How to interrogate optical discs
    ... Robert G. Savage wrote: ... know as accurately as possible the size of that added amount. ... I think it depends entirely on how many directory entries it ... you may have to build an image you think will fit, ...
    (Fedora)
  • Re: model over-parameterization
    ... Given a non-linear model (with a certain amount of parameters) that is ... used to fit the experimental data. ... Adding parameters to the model will necessarily lead to a ...
    (comp.soft-sys.matlab)
  • Re: So whats null then if its not nothing?
    ... > Look, when you create a relation, you are defining a predicate. ... > saying propositions that fit with these variables will be stored here. ... It's easy to put a square peg in a round hole. ...
    (comp.databases.theory)