help pulling the data i want.

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

I have a table that i am trying to get data from. problem is i dont know how
to get just the data i want.

I have a history table table that lists unit serial number, failure, and
replaced components. If a unit has multiple componet replacements i have
multiple entries.

IE:
serial 1234
failure battery not charging
replaced component battery

serial 1234
failure battery not charging
replaced component power connector

I would like to be able to pull the data into a table but ideally would like
to see it like this.

ie: serial 1234 / failure battery not charging / component battery, power
connector.

I dont want to repeat the serial and failure for the components replaced.
Each entry is time/date stamped and has a unique ID so i should be able to
filter on the same date along with serial, failure to get all the compenents
changed but i'm not sure how to get all this.

Any ideas? I can put the data in a report or in a simple table view like if
i ran a sql query. Thanks for any help.

.

Relevant Pages

  • Re: Linux 2.4.28-rc1
    ... Looks OK to me who dont have a clue about PCMCIA (it only tries ... to handle failure case, pretty safe). ... If the maintainer really cares about why didnt he resend me? ... send the line "unsubscribe linux-kernel" in ...
    (Linux-Kernel)
  • Re: Job in IT
    ... Molecule typed: ... bit off topic but I hope I dont get too much abuse. ... design is based on failure, anyone that said they never failed or it was x ...
    (microsoft.public.windowsxp.help_and_support)
  • Disk shows as Healthy (At Risk)
    ... I have come to this system recently so dont have much prior knowledge but ... the Mylex card was replaced a few months back due to some failure or other. ...
    (microsoft.public.win2000.hardware)
  • Re: Cat609 Supervisor card IOS upgrade/downgrade
    ... failed card (given that it wasn't a root cause of failure) to new one. ... With best regards, ... Thanks Andrey. ... and dont be alarmed - it takes ages for the cat to boot from flash-cards. ...
    (comp.dcom.sys.cisco)
  • Re: Silmarillion the movie, any thoughts?
    ... I do think that it could be done, I dont see it (movie) as a standard ... life is doomed to failure and obviously the trilogy was not doomed to ... dismiss the power of popular culture, in the right hand anything is ...
    (rec.arts.books.tolkien)