I HAVE A MS ACCESS 2000 TABLE THAT LOOKS LIKE THIS:
UIC_CD SSN_ID ASGN_CD GRD_CD STATUS_CD
W1U3AA 001327659 7
W1ERAA 001382747 AS 8 CO
W17TAA 001401712 TA 6 TN
WGFXAA 001406994 FC 5 CO
W2H6AA 001409810 TA 7 CO
W0ND4C 001427852 TC 9 TR
WAT3AA 001440295 FC 9 C1
WASFT0 001463259 FC 6 C1
WB5KAA 001464707 E5 6 TN
WFT1T0 001465878 E4 7 CO
WALZB0 001467199 E1 8 C1
W1E0B0 001467241 X1 5 TN
W1D4ZC 001481152 X7 7 CO
2. How do i program in Jet SQL for this result:
CURR_AS TOTAL THS TOE TDA
AS 1 1 0 0
TA 2 1 1 0
FC 3 1 0 2
TC 1 0 1 0
E1 3 1 1 1
X1 2 1 1 0
CONDITIONS: STATUS "CO" = "THS"
STATUS "TN","TR" = "TOE"
STATUS "C1" = "TDA"
AND CURR_AS "E5","E4","E1" = "E1"
AND "X1","X7" = "X1"
3. As you can tell, I am a novice. However, I hope you
see what I am trying to do and can help.
V/r,
UIC_CD SSN_ID ASGN_CD GRD_CD STATUS_CD
W1U3AA 001327659 7
W1ERAA 001382747 AS 8 CO
W17TAA 001401712 TA 6 TN
WGFXAA 001406994 FC 5 CO
W2H6AA 001409810 TA 7 CO
W0ND4C 001427852 TC 9 TR
WAT3AA 001440295 FC 9 C1
WASFT0 001463259 FC 6 C1
WB5KAA 001464707 E5 6 TN
WFT1T0 001465878 E4 7 CO
WALZB0 001467199 E1 8 C1
W1E0B0 001467241 X1 5 TN
W1D4ZC 001481152 X7 7 CO
2. How do i program in Jet SQL for this result:
CURR_AS TOTAL THS TOE TDA
AS 1 1 0 0
TA 2 1 1 0
FC 3 1 0 2
TC 1 0 1 0
E1 3 1 1 1
X1 2 1 1 0
CONDITIONS: STATUS "CO" = "THS"
STATUS "TN","TR" = "TOE"
STATUS "C1" = "TDA"
AND CURR_AS "E5","E4","E1" = "E1"
AND "X1","X7" = "X1"
3. As you can tell, I am a novice. However, I hope you
see what I am trying to do and can help.
V/r,
