J
jfcby
Hello,
I've created a query that accesses a OBDC data base that I cannot
change any data. In my query I have
Field1 Field2 Field3
AHU-A TASK1 DESCRIPTION1
AHU-A TASK2 DESCRIPTION2
AHU-S TASK3 DESCRIPTION3
AHU-S TASK4 DESCRIPTION4
AHU-Q TASK5 DESCRIPTION5
AHU-Q TASK6 DESCRIPTION6
FCU/UV-A TASK7 DESCRIPTION7
FCU/UV-A TASK8 DESCRIPTION8
FCU/UV-S TASK9 DESCRIPTION9
FCU/UV-S TASK10 DESCRIPTION10
FCU/UV-Q TASK11 DESCRIPTION11
FCU/UV-Q TASK12 DESCRIPTION12
FCU/UV-Q TASK13 DESCRIPTION13
TTWHVAC-A TASK14 DESCRIPTION14
TTWHVAC-A TASK15 DESCRIPTION15
TTWHVAC-S TASK16 DESCRIPTION16
TTWHVAC-S TASK17 DESCRIPTION17
TTWHVAC-Q TASK18 DESCRIPTION18
TTWHVAC-Q TASK19 DESCRIPTION19
so I put in field6 Expr2: Right([ROOT_AE_R_PMS_E.PMI_BASIC],1) but my
results in field6 are the last letter from the cells with the most
number of letters and the others are blank.
Field1 Field2 Field3 Field6
AHU-A TASK1 DESCRIPTION1
AHU-A TASK2 DESCRIPTION2
AHU-S TASK3 DESCRIPTION3
AHU-S TASK4 DESCRIPTION4
AHU-Q TASK5 DESCRIPTION5
AHU-Q TASK6 DESCRIPTION6
FCU/UV-A TASK7 DESCRIPTION7
FCU/UV-A TASK8 DESCRIPTION8
FCU/UV-S TASK9 DESCRIPTION9
FCU/UV-S TASK10 DESCRIPTION10
FCU/UV-Q TASK11 DESCRIPTION11
FCU/UV-Q TASK12 DESCRIPTION12
FCU/UV-Q TASK13 DESCRIPTION13
TTWHVAC-A TASK14 DESCRIPTION14 A
TTWHVAC-A TASK15 DESCRIPTION15 A
TTWHVAC-S TASK16 DESCRIPTION16 S
TTWHVAC-S TASK17 DESCRIPTION17 S
TTWHVAC-Q TASK18 DESCRIPTION18 Q
TTWHVAC-Q TASK19 DESCRIPTION19 Q
How can I get the last letter in field1 one to field6? If you need to
see my SQL let me know!
Thank you for your help,
jfcby
I've created a query that accesses a OBDC data base that I cannot
change any data. In my query I have
Field1 Field2 Field3
AHU-A TASK1 DESCRIPTION1
AHU-A TASK2 DESCRIPTION2
AHU-S TASK3 DESCRIPTION3
AHU-S TASK4 DESCRIPTION4
AHU-Q TASK5 DESCRIPTION5
AHU-Q TASK6 DESCRIPTION6
FCU/UV-A TASK7 DESCRIPTION7
FCU/UV-A TASK8 DESCRIPTION8
FCU/UV-S TASK9 DESCRIPTION9
FCU/UV-S TASK10 DESCRIPTION10
FCU/UV-Q TASK11 DESCRIPTION11
FCU/UV-Q TASK12 DESCRIPTION12
FCU/UV-Q TASK13 DESCRIPTION13
TTWHVAC-A TASK14 DESCRIPTION14
TTWHVAC-A TASK15 DESCRIPTION15
TTWHVAC-S TASK16 DESCRIPTION16
TTWHVAC-S TASK17 DESCRIPTION17
TTWHVAC-Q TASK18 DESCRIPTION18
TTWHVAC-Q TASK19 DESCRIPTION19
so I put in field6 Expr2: Right([ROOT_AE_R_PMS_E.PMI_BASIC],1) but my
results in field6 are the last letter from the cells with the most
number of letters and the others are blank.
Field1 Field2 Field3 Field6
AHU-A TASK1 DESCRIPTION1
AHU-A TASK2 DESCRIPTION2
AHU-S TASK3 DESCRIPTION3
AHU-S TASK4 DESCRIPTION4
AHU-Q TASK5 DESCRIPTION5
AHU-Q TASK6 DESCRIPTION6
FCU/UV-A TASK7 DESCRIPTION7
FCU/UV-A TASK8 DESCRIPTION8
FCU/UV-S TASK9 DESCRIPTION9
FCU/UV-S TASK10 DESCRIPTION10
FCU/UV-Q TASK11 DESCRIPTION11
FCU/UV-Q TASK12 DESCRIPTION12
FCU/UV-Q TASK13 DESCRIPTION13
TTWHVAC-A TASK14 DESCRIPTION14 A
TTWHVAC-A TASK15 DESCRIPTION15 A
TTWHVAC-S TASK16 DESCRIPTION16 S
TTWHVAC-S TASK17 DESCRIPTION17 S
TTWHVAC-Q TASK18 DESCRIPTION18 Q
TTWHVAC-Q TASK19 DESCRIPTION19 Q
How can I get the last letter in field1 one to field6? If you need to
see my SQL let me know!
Thank you for your help,
jfcby