Hey guys, I have a database that we are using to keep track of testing on a house and its electrical wiring.
Basically I have the following Fields
Location - Location or Zone.
UNSAT - Unsat condition (no power)
SAT - Sat condition
Tester - Person who retested
Date - Date
and then I have a set of data in case it tested unsat, for it to be tested again...
RT-UNSAT - ReTest UNSAT
RT-SAT - ReTest SAT
RT-Tester - Retester
RT-Date - Date Retested
So what I did was build a crosstab query. The Zone is the Column Heading, the Row Headings are the SAT and UNSAT and then there is a value, that counts the number of UNSAT/SAT signals in the zone.
My problem is, I want to be able to report on the retest.
For example, if I have a location that was tested unsat, and then retested sat. How do I tell the crosstab query that, hey, it was tested unsat, lets look at the retests and see if the retest is unsat or sat? Then use those values in my crosstab query so I can tell how many zones are unsat, or sat, or utested?
Any ideas folks?
Thanks!
Basically I have the following Fields
Location - Location or Zone.
UNSAT - Unsat condition (no power)
SAT - Sat condition
Tester - Person who retested
Date - Date
and then I have a set of data in case it tested unsat, for it to be tested again...
RT-UNSAT - ReTest UNSAT
RT-SAT - ReTest SAT
RT-Tester - Retester
RT-Date - Date Retested
So what I did was build a crosstab query. The Zone is the Column Heading, the Row Headings are the SAT and UNSAT and then there is a value, that counts the number of UNSAT/SAT signals in the zone.
My problem is, I want to be able to report on the retest.
For example, if I have a location that was tested unsat, and then retested sat. How do I tell the crosstab query that, hey, it was tested unsat, lets look at the retests and see if the retest is unsat or sat? Then use those values in my crosstab query so I can tell how many zones are unsat, or sat, or utested?
Any ideas folks?
Thanks!