Hi All,
This is what I have
SELECT qryAFTER_FIX_2.AFTER_FIX
FROM qryDEPARTMENT LEFT JOIN qryAFTER_FIX_2 ON qryDEPARTMENT.SUB_CATAGORY = qryAFTER_FIX_2.SUB_CATAGORY;
The result is:
AFTER_FIX
11
2
1
1
5
1
9
122
N/A should go here
1
1
1
N/A should go here
1
7
1
N/A should go here
5
2
2
21
How do I place "N/A" in the blank spaces above.
Thanks,
regard
This is what I have
SELECT qryAFTER_FIX_2.AFTER_FIX
FROM qryDEPARTMENT LEFT JOIN qryAFTER_FIX_2 ON qryDEPARTMENT.SUB_CATAGORY = qryAFTER_FIX_2.SUB_CATAGORY;
The result is:
AFTER_FIX
11
2
1
1
5
1
9
122
N/A should go here
1
1
1
N/A should go here
1
7
1
N/A should go here
5
2
2
21
How do I place "N/A" in the blank spaces above.
Thanks,
regard